diff options
| -rw-r--r-- | CHANGELOG.md | 164 |
1 files changed, 164 insertions, 0 deletions
diff --git a/CHANGELOG.md b/CHANGELOG.md new file mode 100644 index 0000000..c86c497 --- /dev/null +++ b/CHANGELOG.md @@ -0,0 +1,164 @@ +# Change Log + +## [Unreleased] + +## [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 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`. + +## [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. + |