Phpmyadmin Sql Parser Versions Save

A validating SQL lexer and parser with a focus on MySQL dialect.

5.9.0

3 months ago
  • 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

7 months ago

Fixed ALTER .. MODIFY ... ENUM failed! #511

5.8.1

7 months ago
  • 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

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

5.7.0

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

5.6.0

1 year ago
  • Add missing return types annotations (746f48fae61c7a21951d51c5823869ebb43d7da1) by @MauricioFauth
  • Improve the WITH statements parser (#363) by @iifawzi
  • Add support for passing Context::SQL_MODE* constants to Context::setMode method by @MauricioFauth
  • Fix additional body tokens issue with CREATE VIEW statements (#371) by @iifawzi
  • Exclude from composer vendor bundle /tests and /phpunit.xml.dist (a20131487496892d4111c1cbe0025fee35180cce) by @williamdes
  • Support table structure with COMPRESSED columns (#351) by @iifawzi
  • Add #[\AllowDynamicProperties] on Statement and Expression classes for PHP 8.2 support (4ee76d94525a092df6b6ea1109171bfc9bc73f52) by @williamdes
  • Support ALTER queries of PARTITIONS (#329) by @iifawzi
  • Fixed differentiating between ANALYZE and EXPLAIN statements (#386) by @iifawzi
  • Added "NOT" to the select options (#374, #391) by @iifawzi
  • Implement the EXPLAIN Parser (#389) by @iifawzi
  • Context: Updated contexts to contain multipoint and multipolygon data types (#393) by @iifawzi
  • Support more keywords on Expression component (#399) by @iifawzi
  • Fix PHP 8.3 failing tests (#400) by @iifawzi
  • Add funding to GitHub and composer.json by @williamdes
  • Add search keywords in the composer.json (#401) by @imanghafoori1

4.7.3

2 years ago

Released version 4.7.3

5.5.0

2 years ago

Released version 5.5.0

5.4.2

3 years ago

Released version 5.4.2

4.7.2

3 years ago

Released version 4.7.2