CHANGELOG.md

Change Log

[6.0.x] - YYYY-MM-DD

• Drop support for PHP 7.2, 7.3, 7.4 and 8.0
• Move Misc::getAliases() into SelectStatement::getAliases() (#454)
• Drop USE_UTF_STRINGS constant (#471)

[5.9.0] - 2024-01-20

• Fix keywords not being recognized as table alias (#496)
• Add bin/sql-parser executable file (#517)
• Fix bind parameter in LIMIT OFFSET (#498)
• Fix using ? as a parameter (#515)

[5.8.2] - 2023-09-19

• Fix a regression with the ALTER operation (#511)

[5.8.1] - 2023-09-15

• Fix := was not recognized as an operator just like = (#306)
• Fix ALTER TABLE … MODIFY … ENUM('<reserved_keyword>') is being wrongly parsed (#234)
• Fix ALTER TABLE … MODIFY … ENUM('<reserved_keyword>') is being wrongly parsed (#478)
• Fix MariaDB window function with alias gives bad linting errors (#283)
• Fix unrecognized keyword COLLATE in WHERE clauses (#491)
• Fix invalid hexadecimal prefix 0X (#508)

[5.8.0] - 2023-06-05

• Fix ALTER EVENT RENAME TO to use expression instead of var (#419)
• Fix incorrect order of operations to parse table/db called `` (#422)
• Fix ALTER EVENT statement with DEFINER=user modifier fails to be parsed (#418)
• Fix GROUP BY modifier WITH ROLLUP is treated as a syntax error and prevents export of SQL query results
• Fix TokensList::getPrevious was not able to reach very first token (#428)
• Fix TransactionStatement::build() "Call to a member function build() on null" when the transaction has no end
• Fix MySQL-specific commands parsing (#226)
• Fix ALTER TABLE … RENAME COLUMN … TO … is not understood by the parser/linter (#430)
• Fix PARTITION syntax errors (#377)
• Fix ALTER USER when used with IDENTIFIED WITH/VIA/BY option (#431)
• Fix COALESCE PARTITION in ALTER TABLE, rather than COALESCE (#323)
• Support ALGORITHM and LOCK options in ALTER TABLE statements (#319)
• Fix way end of functions, procedures and triggers' bodies is identified (#438)
• Fix enclosed by is not recognized by the parser when fields is in lower case (#236)
• Support KEY on CreateDefinition (#330)
• Fix CALL statements parsing (#372)
• Implement support for LEFT JOIN, JOIN, INNER JOIN on UpdateStatement (#260)
• Implement support for TABLE and REPLACE statements on DESCRIBE statements
• Fix DESCRIBE to allow a schema.table syntax (#445)
• Fix parsing insert queries with functions trims commas (#450)

[5.7.0] - 2023-01-25

• Performance improvement to use less the nextToken() function (#397)
• Lexer - Solving ambiguity on function keywords (#385)
• Implement ALTER EVENT (#404)
• Add ALTER EVENT keywords (#404)
• Drop PHP 7.1 support
• Fix the alter operation table options RENAME INDEX x TO y (#405)
• Fix CreateStatement function's options (#406)
• Fix a PHP notice on Linter using ANALYZE (#413)

[5.6.0] - 2023-01-02

• Add missing return types annotations
• Improve the WITH statements parser (#363)
• Add support for passing Context::SQL_MODE* constants to Context::setMode method
• Fix additional body tokens issue with CREATE VIEW statements (#371)
• Exclude from composer vendor bundle /tests and /phpunit.xml.dist
• Support table structure with COMPRESSED columns (#351)
• Add #[\AllowDynamicProperties] on Statement and Expression classes for PHP 8.2 support
• Support ALTER queries of PARTITIONS (#329)
• Change Context::load() error handling to returning a boolean value instead of throwing a LoaderException (#384)
• Fixed differentiating between ANALYZE and EXPLAIN statements (#386)
• Added "NOT" to the select options (#374)
• Implement the EXPLAIN Parser (#389)
• Context: Updated contexts to contain multipoint and multipolygon data types (#393)
• Support more keywords on Expression component (#399)
• Fix PHP 8.3 failing tests (#400)

[5.5.0] - 2021-12-08

• Add WITH support (#165, #331)
• Fixed BufferedQuery when it has an odd number of backslashes in the end (#340)
• Fixed the issue that ignored the body tokens when creating views with union (#343)
• Fixed parser errors on "ALTER TABLE" statements to add columns with SET type (#168)
• Fixed PHP 8.1 fatal errors on classes that "implements ArrayAccess"
• Add new contexts for MariaDB 10.4, 10.5, 10.6 (#328)
• Fixed parser errors for "ALTER USER" with options (#342)
• Fixed handling of the procedures and functions's options where part of the body (#339)
• Fix PHP notice "Undefined index: name in src/Components/Key.php#206" for table keys using expressions (#347)
• Added support for MySQL 8.0 table structure KEY expressions (#347)
• Added support for KEY order (ASC/DESC) (#296)
• Added missing KEY options for MySQL and MariaDB (#348)
• Added support for ENFORCED and NOT ENFORCED on table create queries (#341)
• Performance improvement to use less the "ord()" function (#352)
• Added support for OVER() with an alias (AS) (#197)

[5.4.2] - 2021-02-05

• Added check for quoted symbol to avoid parser error in case of keyword (#317)
• Allow PHP 8

[5.4.1] - 2020-10-15

• Fix array_key_exists warning when parsing a "DEFAULT FALSE" token (#299)

[5.4.0] - 2020-10-08

• EXISTS is also a function. (#297)
• Fix lexer to not allow numbers with letters (#300)
• Add support for INVISIBLE keyword (#292)
• Fix the "$" might be a character used in a name (#301)
• Fix use stream_select instead of non-blocking STDIN (#309)
• Add select validation to a create view statement (#310)

[5.3.1] - 2020-03-20

• Revert some changes with the understanding of ANSI_QUOTES mode and identifiers
• Suggest motranslator 5.0 in README

[5.3.0] - 2020-03-20

• Stop instanciating an object to check its class name. (#290)
• Replace sscanf by equivalent native PHP functions because sscanf can be disabled for security reasons. (#270)
• Allow phpunit 9
• Allow phpmyadmin/motranslator 5.0
• Fix for php error when "INSERT INTO x SET a = 1" is "INSERT INTO x SET = 1" (#295)
• Fixed lexer fails to detect "*" as a wildcard (#288)
• Fixed ANSI_QUOTES support (#284)
• Fixed parser mistakes with comments (#156)

[5.2.0] - 2020-01-07

• Fix ALTER TABLE ... PRIMARY/UNIQUE KEY results in error (#267)
• Prevent overwrite of offset in Limit clause by parenthesis (#275)
• Allow SCHEMA to be used in CREATE Database statement (#231)
• Add missing options in SET statement (#255)
• Add support for DROP USER statement (#259)
• Fix php error "undefined index" when replacing a non existing clause (#249)

[5.1.0] - 2019-11-12

• Fix for PHP deprecations messages about implode for php 7.4+ (#258)
• Parse CHECK keyword on table definition (#264)
• Parse truncate statement (#221)
• Fix wrong parsing of partitions (#265)

[5.0.0] - 2019-05-09

• Drop support for PHP 5.3, PHP 5.4, PHP 5.5, PHP 5.6, PHP 7.0 and HHVM
• Enable strict mode on PHP files
• Fix redundant whitespaces in build() outputs (#228)
• Fix incorrect error on DEFAULT keyword in ALTER operation (#229)
• Fix incorrect outputs from Query::getClause (#233)
• Add support for reading an SQL file from stdin
• Fix for missing tokenize-query in Composer's vendor/bin/ directory
• Fix for PHP warnings with an incomplete CASE expression (#241)
• Fix for error message with multiple CALL statements (#223)
• Recognize the question mark character as a parameter (#242)

[4.7.4] - YYYY-MM-DD

[4.7.3] - 2021-12-08

• Fixed BufferedQuery when it has an odd number of backslashes in the end (#340)
• Fixed the issue that ignored the body tokens when creating views with union (#343)
• Fixed parser errors on "ALTER TABLE" statements to add columns with SET type (#168)
• Fixed parser errors for "ALTER USER" with options (#342)
• Fixed handling of the procedures and functions's options where part of the body (#339)
• Fix PHP notice "Undefined index: name in src/Components/Key.php#206" for table keys using functions (#347)
• Fix MySQL 8.0 table structure KEY expression not recognized (#347)
• Fix KEY order (ASC/DESC) not part of the KEY definition (#296)
• Fix missing KEY options for MySQL and MariaDB (#348)
• Fix validation error when using ENFORCED option (#341)

[4.7.2] - 2021-02-05

• Added check for quoted symbol to avoid parser error in case of keyword (#317)
• Adjust PHP version constraint to not support PHP 8.0 on the 4.7 series (5.x series supports it)

[4.7.1] - 2020-10-15

• Fix array_key_exists warning when parsing a "DEFAULT FALSE" token (#299)

[4.7.0] - 2020-10-08

• EXISTS is also a function. (#297)
• Fix lexer to not allow numbers with letters (#300)
• Add support for INVISIBLE keyword (#292)
• Fix the "$" might be a character used in a name (#301)
• Fix use stream_select instead of non-blocking STDIN (#309)
• Add select validation to a create view statement (#310)

[4.6.1] - 2020-03-20

• Revert some changes with the understanding of ANSI_QUOTES mode and identifiers
• Suggest motranslator 4.0 in README

[4.6.0] - 2020-03-20

• Stop instanciating an object to check its class name. (#290)
• Replace sscanf by equivalent native PHP functions because sscanf can be disabled for security reasons. (#270)
• Allow phpunit 7
• Fix for php error when "INSERT INTO x SET a = 1" is "INSERT INTO x SET = 1" (#295)
• Fixed lexer fails to detect "*" as a wildcard (#288)
• Fixed ANSI_QUOTES support (#284)
• Fixed parser mistakes with comments (#156)

[4.5.0] - 2020-01-07

• Fix ALTER TABLE ... PRIMARY/UNIQUE KEY results in error (#267)
• Prevent overwrite of offset in Limit clause by parenthesis (#275)
• Allow SCHEMA to be used in CREATE Database statement (#231)
• Add missing options in SET statement (#255)
• Add support for DROP USER statement (#259)
• Fix php error "undefined index" when replacing a non existing clause (#249)

[4.4.0] - 2019-11-12

• Fix for PHP deprecations messages about implode for php 7.4+ (#258)
• Parse CHECK keyword on table definition (#264)
• Parse truncate statement (#221)
• Fix wrong parsing of partitions (#265)

[4.3.2] - 2019-06-03

Backport fixes from 5.0.0 to QA branch:

• Fix redundant whitespaces in build() outputs (#228)
• Fix incorrect error on DEFAULT keyword in ALTER operation (#229)
• Fix incorrect outputs from Query::getClause (#233)
• Add support for reading an SQL file from stdin
• Fix for missing tokenize-query in Composer's vendor/bin/ directory
• Fix for PHP warnings with an incomplete CASE expression (#241)
• Fix for error message with multiple CALL statements (#223)
• Recognize the question mark character as a parameter (#242)

[4.3.1] - 2019-01-05

• Fixed incorrect error thrown on DEFAULT keyword in ALTER statement (#218)

[4.3.0] - 2018-12-25

• Add support for aliases on CASE expressions (#162 and #192)
• Add support for INDEX hints in SELECT statement (#199)
• Add support for LOCK and UNLOCK TABLES statement (#180)
• Add detection of extraneous comma in UPDATE statement (#160)
• Add detection of a missing comma between two ALTER operations (#189)
• Add missing support for STRAIGHT_JOIN (#196)
• Add support for end options in SET statement (#190)
• Fix building of RENAME statements (#201)
• Add support for PURGE statements (#207)
• Add support for COLLATE keyword (#190)

[4.2.5] - 2018-10-31

• Fix issue with CREATE OR REPLACE VIEW.

[4.2.4] - 2017-12-06

• Fix parsing of CREATE TABLE with per field COLLATE.
• Improved Context::loadClosest to better deal with corner cases.
• Localization updates.

[4.2.3] - 2017-10-10

• Make mbstring extension optional (though Symfony polyfill).
• Fixed build CREATE TABLE query with PARTITIONS having ENGINE but not VALUES.

[4.2.2] - 2017-09-28

• Added support for binding parameters.

[4.2.1] - 2017-09-08

• Fixed minor bug in Query::getFlags.
• Localization updates.

[4.2.0] - 2017-08-30

• Initial support for MariaDB SQL contexts.
• Add support for MariaDB 10.3 INTERSECT and EXCEPT.

[4.1.10] - 2017-08-21

• Use custom LoaderException for context loading errors.

[4.1.9] - 2017-07-12

• Various code cleanups.
• Improved error handling of several invalid statements.

[4.1.8] - 2017-07-09

• Fixed parsing SQL comment at the end of query.
• Improved handing of non utf-8 strings.
• Added query flag for SET queries.

[4.1.7] - 2017-06-06

• Fixed setting combination SQL Modes.

[4.1.6] - 2017-06-01

• Fixed building query with GROUP BY clause.

[4.1.5] - 2017-05-15

• Fixed invalid lexing of queries with : in strings.
• Properly handle maximal length of delimiter.

[4.1.4] - 2017-05-05

• Fixed wrong extract of string tokens with escaped characters.
• Properly handle lowercase begin statement.

[4.1.3] - 2017-04-06

• Added support for DELETE ... JOIN clauses.
• Changed BufferedQuery to include comments in output.
• Fixed parsing of inline comments.

[4.1.2] - 2017-02-20

• Coding style improvements.
• Chinese localization.
• Improved order validatin for JOIN clauses.
• Improved pretty printing of JOIN clauses.
• Added support for LOAD DATA statements.

[4.1.1] - 2017-02-07

• Localization using phpmyadmin/motranslator is now optional.
• Improved testsuite.
• Better handling of non upper cased not reserved keywords.
• Minor performance and coding style improvements.

[4.1.0] - 2017-01-23

• Use phpmyadmin/motranslator to localize messages.

[4.0.1] - 2017-01-23

• Fixed CLI wrappers for new API.
• Fixed README for new API.

[4.0.0] - 2017-01-23

• Added PhpMyAdmin namespace prefix to follow PSR-4.

[3.4.17] - 2017-01-20

• Coding style fixes.
• Fixed indentation in HTML formatting.
• Fixed parsing of unterminated variables.
• Improved comments lexing.

[3.4.16] - 2017-01-06

• Coding style fixes.
• Properly handle operators AND, NOT, OR, XOR, DIV, MOD

[3.4.15] - 2017-01-02

• Fix return value of Formatter.toString() when type is text
• Fix parsing of FIELDS and LINES options in SELECT..INTO
• PHP 7.2 compatibility.
• Better parameter passing to query formatter.

[3.4.14] - 2016-11-30

• Improved parsing of UNION queries.
• Recognize BINARY function.

[3.4.13] - 2016-11-15

• Fix broken incorrect clause order detection for Joins.
• Add parsing of end options in Select statements.

[3.4.12] - 2016-11-09

• Added verification order of SELECT statement clauses.

[3.4.11] - 2016-10-25

• Fixed parsing of ON UPDATE option in field definition of TIMESTAMP type with precision
• Fixed parsing of NATURAL JOIN, CROSS JOIN and related joins.
• Fixed parsing of BEGIN/END labels.

[3.4.10] - 2016-10-03

• Fixed API regression on DELETE statement

[3.4.9] - 2016-10-03

• Added support for CASE expressions
• Support for parsing and building DELETE statement
• Support for parsing subqueries in FROM clause

[3.4.8] - 2016-09-22

• No change release to sync GitHub releases with Packagist

[3.4.7] - 2016-09-20

• Fix parsing of DEFINER without backquotes
• Fixed escaping HTML entities in HTML formatter
• Fixed escaping of control chars in CLI formatter

[3.4.6] - 2016-09-13

• Fix parsing of REPLACE INTO ...
• Fix parsing of INSERT ... ON DUPLICATE KEY UPDATE ...
• Extended testsuite
• Re-enabled PHP 5.3 support

[3.4.5] - 2016-09-13

• Fix parsing of INSERT...SELECT and INSERT...SET syntax
• Fix parsing of CREATE TABLE ... PARTITION
• Fix parsing of SET CHARACTER SET, CHARSET, NAMES
• Add Support for 'CREATE TABLE table_copy LIKE table

[3.4.4] - 2016-04-26

• Add support for FULL OUTER JOIN

[3.4.3] - 2016-04-19

• Fix parsing of query with \

[3.4.2] - 2016-04-07

• Recognize UNION DISTINCT
• Recognize REGEXP and RLIKE operators

[3.4.1] - 2016-04-06

• Add FULLTEXT and SPATIAL keywords
• Properly parse CREATE TABLE [AS] SELECT
• Fix parsing of table with DEFAULT and COMMENT

[3.4.0] - 2016-02-23

• Fix parsing DEFAULT value on CREATE
• Fix parsing of ALTER VIEW

[3.3.1] - 2016-02-12

• Condition: Allow keyword INTERVAL.

[3.3.0] - 2016-02-12

• Expression: Refactored parsing options.

[3.2.0] - 2016-02-11

• Context: Added custom mode that avoids escaping when possible.

[3.1.0] - 2016-02-10

• ArrayObj: Handle more complex expressions in arrays.
• BufferedQuery: Backslashes in comments escaped characters in comments.
• Condition: Allow IF in conditions.
• Context: Add ; as operator.
• Context: Updated contexts to contain BIT data type.
• CreateStatement: The DEFAULT option may be an expression.
• DescribeStatement: Added DESC as alias for DESCRIBE.
• Expression: Rewrote expression parsing.
• Misc: Added PHPUnit's Code Coverage 3.0 as a dependency.
• Misc: Added support for PHP 5.4 back.
• Misc: Removed dependency to Ctype.
• Misc: Repository transferred from @udan11 to @phpMyAdmin.
• Misc: Updated .gitignore to ignore composer.lock.
• Misc: Updated Composer and Travis configuration for PHP 7 and PHPUnit 5.
• Tools: Documented tags in ContextGenerator.

[3.0.8] - 2015-12-18

• Allow NULL in expressions.
• Downgraded PHPUnit to 4.8. Removed old PHP versions.
• Updated PHPUnit to 5.1 and fixed some of the tests.
• Added UNION ALL as a type of UNION.
• Expressions are permitted in SET operations.
• Added STRAIGHT_JOIN as a known type of join.
• Added missing definitions for MATCH and AGAINST.
• Added missing statement (FLUSH and DEALLOCATE).

[3.0.7] - 2015-11-12

• Expressions may begin with a function that is also a reserved keyword (e.g. IF).

[3.0.6] - 2015-11-12

• Fixed a bug where formatter split the function name and the parameters list.

[3.0.5] - 2015-11-08

• Add GRANT as known statement.
• Use JOIN expressions for flag detection.
• Fix the order of clauses in SELECT statements involving UNIONs.
• Added dummy parsers for CREATE USER and SET PASSWORD statements.
• Accept NOT operator in conditions.
• Fixed DELIMITER statements in BufferedQuery.
• Added INSERT statement builder.

[3.0.4] - 2015-10-21

• Fix error message in SqlParser\Components\OptionsArray.

[3.0.3] - 2015-10-10

• Avoid building a field multiple times if clause has synonyms.

[3.0.2] - 2015-10-10

• Add EXISTS as an acceptable keyword in conditions.

[3.0.1] - 2015-10-06

• Handle backslashes separately for SqlParser\Utils\BufferedQuery. Fixes a bug where backslashes in combination with strings weren't handled properly.

[3.0.0] - 2015-10-02

Breaking changes:

• SqlParser\Components\Reference::$table is now an instance of SqlParser\Components\Expression to support references from other tables.

[2.1.3] - 2015-10-02

• Add definitions for all JOIN clauses.

[2.1.2] - 2015-10-02

• Properly parse options when the value of the option is '='.

[2.1.1] - 2015-09-30

• Only RANGE and LIST type partitions support VALUES.

[2.1.0] - 2015-09-30

• Added utilities for handling tokens and tokens list.

[2.0.3] - 2015-09-30

• Added missing NOT IN operator. This caused troubles when parsing conditions that contained the NOT IN operator.

[2.0.2] - 2015-09-30

• Added support for OUTER as an optional keyword in joins.

[2.0.1] - 2015-09-30

• Fixed a bug related to (sub)partitions options not being included in the built component. Also, the option ENGINE was unrecognized.

[2.0.0] - 2015-09-25

• Better parsing for CREATE TABLE statements (related to breaking change 1).
• Added support for JSON data type.
• Refactoring and minor documentation improvements.

Breaking changes:

• SqlParser\Components\Key::$columns is now an array of arrays. Each array must contain a name key which represents the name of the column and an optional length key which represents the length of the column.

[1.0.0] - 2015-08-20

• First release of this library.