JSQLParser/JSqlParser
 Watch   
 Star   
 Fork   
简介统计版本
2024-07-01 04:53:13
JSqlParser
JSQLParser

jsqlparser-5.0

What's Changed

Changes and new Features

New Contributors

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-4.9...jsqlparser-5.0

2024-03-10 04:59:50
JSqlParser
JSQLParser

jsqlparser-4.9

What's Changed

Changes and new Features

New Contributors

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-4.8...jsqlparser-4.9

2023-12-28 08:17:15
JSqlParser
JSQLParser

jsqlparser-4.8

What's Changed

Changes and new Features

New Contributors

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-4.7...jsqlparser-4.8

2023-09-02 06:16:29
JSqlParser
JSQLParser

jsqlparser-4.7

What's Changed

Changes and new Features

New Contributors

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-4.6...jsqlparser-4.7

2023-02-24 05:22:15
JSqlParser
JSQLParser

jsqlparser-4.6

What's Changed

Changes and new Features

New Contributors

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-4.5...jsqlparser-4.6

2022-07-23 06:51:05
JSqlParser
JSQLParser

jsqlparser-4.5

  • UnsupportedStatement support instead of throwing Exceptions
  • support for RETURNING clause of a DELETE statement
  • Add support for ... ALTER COLUMN ... DROP DEFAULT
  • INSERT supports SetOperations (e. g. INSERT INTO ... SELECT ... FROM ... UNION SELECT ... FROM ...), those SetOperations are used both for SELECT and VALUES clauses (API change) in order to simplify the Grammar
  • (WITH ... SELECT ...) statements within brackets are now supported
  • Postgres NATURAL { INNER | LEFT | RIGHT } JOIN support
  • extended support for Hive dialect GROUPING SETS
  • support for Postgresql drop function
  • support table option character set and index options
  • support Postgresql optional TABLE in TRUNCATE
  • support for ANALYZE mytable
  • PostgreSQL INSERT INTO ... ON CONFLICT ... DO ... statements
  • implement Parser Timeout Feature, e. g. CCJSqlParserUtil.parse(sqlStr, parser -> parser.withTimeOut(60000));
  • extended support Postgres' Extract( field FROM source) where field is a String instead of a Keyword
  • support for DROP column IF EXISTS

What's Changed

Changes and new Features

2022-04-11 04:34:44
JSqlParser
JSQLParser

JSqlParser 4.4

  • support for timestamp with local time zone
  • improved support for quoted identifiers in casts
  • support for top with ties
  • support for operators <-> and <#>
  • improvement of test methods
  • validation bugfixes
  • Json function Improvements and Bugfix #1506
2021-12-12 23:28:44
JSqlParser
JSQLParser

jsqlparser-4.3

  • moved to JUnit 5 as a test framework
  • added IGNORE NULLS to window functions
  • Postgres compliant ALTER TABLE schema.oldTableName RENAME TO newTableName
  • added use of * or mytable.* as a function parameter
  • enhanced support for ddl drop of indexes
  • support alias for Unpivot statement
  • support for limit and offset expressions
  • support for special JSON_OBJECT function parsing
  • allow ComplexExpressions for CASE expression (preview)
  • support MYSQL modifiers for DELETE / UPDATE
  • support for Postgres Dollar quotation: $$mystring$$
  • support for expression in escaping of a like expression: LIKE ? ESCAPE ?
  • support for CREATE OR REPLACE TABLE
  • support for multi column unpivot
  • support for RESTART in Postgres ALTER SEQUENCE
  • improved support of IGNORE NULLS in window functions
  • upgraded some maven plugin versions
2021-09-08 17:40:23
JSqlParser
JSQLParser

JSqlParser 4.2

  • API change: Support SELECT ... without a FROM clause, making SELECT 1, 2 and SELECT * parsable statements (before those failed)
  • API change: Support complex UPDATE sets (using multiple SubQuery or ValueList or Single Values, in combination)
  • Support nested CASE expressions with complex expression arguments
  • API change: Support JOIN with multiple trailing ON Expressions (JOIN ... JOIN ... ON ... ON ...)
  • Support Oracle Hierarchical CONNECT_BY_ROOT Operator
  • Support Transact-SQL IF ... ELSE ... Statement Control Flows.
  • Allow optional parameters for the ALTER TABLE ... statement (e.g. ALTER TABLE ... MOVE TABLESPACE ...)
  • Support Oracle ALTER SYSTEM ... statement
  • Support Oracle Named Function ParametersFunc( param1 => arg1, ...
  • Add Gradle build
  • Allow JdbcParameter or JdbcNamedParameter for MySQL FullTextSearch
  • Allow Cast into Row Constructor
  • Support Oracle RENAME ... TO ... statement
  • Support Oracle PURGE statement
  • Support JSON functions JSON_OBJECT(), JSON_ARRAY(), JSON_OBJECTAGG(), JSON_ARRAYAGG()
  • API change: merge ALL and ANY expressions class
  • Allow DB2 compliant CURRENT DATEin addition to CURRENT_DATE (without underscore)
2021-07-01 06:05:44
JSqlParser
JSQLParser

jsqlparser-4.1

  • RESET statement
  • SET LOCAL|SESSION
  • support for nested WITH CTEs
  • support for with (cte) for delete, update and merge
  • introduce a max depth to allow parsing complex expression lists without performance loss (thx to @manticore-projects)
  • allow all functions to have complex expressions as parameters (thx to @manticore-projects)
  • API change FunctionWithCondParams production removed
  • API change in ValuesStatement: the expression list is now hold as a ItemList and not as a List
  • support for parser modification within parseExpression and parseCondExpression
  • support for table schema for foreign keys
  • support for Oracle hints on insert, update and merge
  • support for merge insert where clause
  • allow in as schema name
  • allow skip, algorithm as column name
  • support for functions in an interval expression
  • subArray support arr[1:3]
  • first support for tuples as simple expression SELECT myfunc((f1, f2))
  • support for array constructors array[[1, 2], [id1, id2]]
  • added support for NOT in MySqls REGEXP clause
  • added support for WITH mytble as ( .. ) INSERT INTO ...
  • added support for H2 casewhen function with conditional parameters