v2.1.15

What's Changed

• Fix the behavior of HAVING clause by @JanJakes in #154
• Fix & improve ON UPDATE trigger behavior by @JanJakes in #156
• Fix creating a table with AUTOINCREMENT and ON UPDATE followed by PRIMARY KEY by @JanJakes in #158

New Contributors

• @JanJakes made their first contribution in #147

Full Changelog: v2.1.14...v2.1.15

v2.1.14

What's Changed

• Fix invalid default values in show create output by @jeroenpf in #141
• Add support for optional COLUMN in ALTER TABLE CHANGE query by @costasovo in #142
• Allow ALTER TABLE to operate on columns without COLUMN keyword by @brandonpayton in #145
• Add support for selecting journal mode by @aristath in #137
• Ensure that an index is also created using IF NOT EXISTS if it comes from a CREATE TABLE IF NOT EXISTS by @akirk in #134
• Add handling for adding/modifying columns with FIRST/AFTER by @JanJakes in #147
• Add support for ON UPDATE CURRENT_TIMESTAMP columns by @JanJakes in #150
• Add support for CURRENT_TIMESTAMP() calls with parentheses by @JanJakes in #151
• Sqlite: Fix LIKE BINARY queries by @kozer in #149

New Contributors

• @costasovo made their first contribution in #142
• @JanJakes made their first contribution in #147

Full Changelog: v2.1.13...v2.1.14

v2.1.13

Full Changelog: v2.1.12...v2.1.13

v2.1.12

What's Changed

• Bugfixes in SHOW CREATE TABLE and SHOW TABLES by @adamziel in #117
• Support multi-value column type modifiers for _mysql_data_types_cache by @jeroenpf in #126
• Support CREATE TABLE unique keys with no key name by @akirk in #130
• Address PK issues for show create table queries by @jeroenpf in #127
• Ensure wp core functions exist before using them by @jeroenpf in #135
• Fix length of index names for a create table statement by @jeroenpf in #133
• Fix PHP 8 issue with strtoupper() by @aristath in #132
• Allow double underscores in index names by @jeroenpf in #136

New Contributors

• @jeroenpf made their first contribution in #126
• @akirk made their first contribution in #130

Full Changelog: v2.1.11...v2.1.12

v2.1.11

What's Changed

• ON DUPLICATE KEY: Prevent adding a comma if key isn't in the first position by @bgrgicak in #113

Full Changelog: v2.1.10...v2.1.11

v2.1.10

What's Changed

• Add PHP7 polyfills
• Support UPDATE LIMIT by @kozer in #93
• Support FORCE INDEX queries by @adamziel in #95
• Add support for SHOW CREATE TABLE queries by @adamziel in #96
• Add a CS workflow & fix issues by @aristath in #101
• CI: Run PHPUnit tests by @adamziel in #99
• Tolerate selecting MySQL system variables by @brandonpayton in #109

New Contributors

• @kozer made their first contribution in #93
• @brandonpayton made their first contribution in #109

Full Changelog: v2.1.9...v2.1.10

v2.1.9

What's Changed

• Fix default null values and NULL value update edge case by @bgrgicak in #94

Full Changelog: v2.1.8...v2.1.9

v2.1.8

What's Changed

• Support SHOW GRANTS FOR by @adamziel in #87
• Support for MySQL LEFT() function by @adamziel in #86
• Support UNHEX() function by @adamziel in #88
• Add support for SHOW TABLE STATUS LIKE queries by @adamziel in #77
• Add support for running queries without STRICT_TRANS_TABLES mode by @bgrgicak in #91
• Replace <<<SQL with " to fix PHP 7 compatibility by @bgrgicak in #92

Full Changelog: v2.1.7...v2.1.8

v2.1.7

What's Changed

• Replace protected consts with consts by @bgrgicak in #82

New Contributors

• @bgrgicak made their first contribution in #82

Full Changelog: v2.1.6...v2.1.7

v2.1.6

v2.1.6