Skip to content

CHANGELOG.md

Latest commit

 

History

History
407 lines (265 loc) · 12 KB

CHANGELOG.md

File metadata and controls

407 lines (265 loc) · 12 KB

Change Log

[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)
  • Remove some useless dev-dependencies
  • 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

  • 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.