Skip to content

Releases: phpmyadmin/sql-parser

v3.1.0

21 Feb 13:27
Compare
Choose a tag to compare
  • 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 transfered 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.

v3.0.8

21 Feb 13:24
Compare
Choose a tag to compare
  • 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).

v3.0.7

17 Nov 20:26
Compare
Choose a tag to compare
  • Expressions may begin with a function that is also a reserved keyword (e.g. IF).

v3.0.6

12 Nov 21:43
Compare
Choose a tag to compare
  • Fixed a bug where formatter split the function name and the parameters list.

v3.0.5

12 Nov 21:44
Compare
Choose a tag to compare
  • 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.

v3.0.4

21 Oct 20:14
Compare
Choose a tag to compare
  • Fix error message in SqlParser\Components\OptionsArray.

v3.0.3

10 Oct 12:51
Compare
Choose a tag to compare
  • Avoid building a field multiple times if clause has synonyms.

v3.0.2

10 Oct 12:51
Compare
Choose a tag to compare
  • Add EXISTS as an acceptable keyword in conditions.

v3.0.1

06 Oct 20:14
Compare
Choose a tag to compare
  • Handle backslashes separately for SqlParser\Utils\BufferedQuery. Fixes a bug where backslashes in combination with strings weren't handled properly.

v3.0.0

03 Oct 09:32
Compare
Choose a tag to compare

Breaking changes:

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