v2.2.4

What's Changed

• New SQLite driver (experimental):
  • Add support for MySQL user variables by @JanJakes in #214
  • Add basic support for MySQL system variables by @JanJakes in #214
  • Add better support for SET statements by @JanJakes in #214
  • Add Query Monitor support by @JanJakes in #212 and #217
  • Add support for INFORMATION_SCHEMA.SCHEMATA table and SHOW DATABASES statement by @JanJakes in #213
  • Use utf8mb4_0900_ai_ci as the default collation as per MySQL 8 by @JanJakes in #213
  • Require using session database name and verify its value by @JanJakes in #213
  • Use correct MySQL-compatible result column names in all scenarios by @JanJakes in #214
  • Fix LIKE in SHOW COLUMN being applied to table name instead of column name by @JanJakes in #211
  • Add a test for more complex information schema queries by @JanJakes in #208

Full Changelog: v2.2.3...v2.2.4

v2.2.3

What's Changed

• New SQLite driver (experimental):
  • Make nullable $previous optional in class-wp-sqlite-information-schema-exception.php by @adamziel in #199
  • Use SQLite driver in WpdbExposedMethodsForTesting by @JanJakes in #201
  • Use default value when DB_NAME constant is not defined by @JanJakes in #203
  • Don't require WordPress to be fully loaded in WP CLI by @JanJakes in #205

Full Changelog: v2.2.2...v2.2.3

v2.2.2

What's Changed

• New SQLite driver (experimental): Implement ADD INDEX and DROP INDEX by @JanJakes in #196
• Require DB_NAME to be set only in the new driver by @JanJakes in #197

Full Changelog: v2.2.1...v2.2.2

v2.2.1

What's Changed

• Fix the WordPress Plugin Directory release.

Full Changelog: v2.2.0...v2.2.1

v2.2.0

What's Changed

• The plugin now requires PHP 7.2 or newer.
• The plugin now supports PHP 8.4.
• The plugin now requires only PDO and PDO SQLite. The SQLite3 PHP extension is no longer required.
• Added support for information schema queries with WHERE, ORDER BY, and AS.
• Fixed error when a column name equals a keyword name (e.g., a column named timestamp).
• New SQLite driver for advanced MySQL compatibility (experimental) by @JanJakes:
  • The new driver can be enabled using define( 'WP_SQLITE_AST_DRIVER', true );.
  • Advanced support of the MySQL syntax.
  • Advanced support for subqueries.
  • Advanced support for UNION and UNION ALL operators.
  • Advanced support for SHOW and DESCRIBE statements.
  • Advanced support for INFORMATION_SCHEMA tables.
  • Advanced support for TEMPORARY tables.
  • Advanced support for table administration statements (TRUNCATE, ANALYZE, CHECK OPTIMIZE, REPAIR).
  • Support for STRICT_TRANS_TABLES and STRICT_ALL_TABLES SQL modes.
  • Support for NO_BACKSLASH_ESCAPES SQL mode.
  • Support for USE <database> statement for the main database and INFORMATION_SCHEMA.
  • Automatic migration of databases created with the legacy driver.
  • The driver is tested against the WordPress PHPUnit test suite, passing most of the tests.
  • The driver requires SQLite 3.37.0 or newer.

Full Changelog: v2.1.16...v2.2.0

v2.1.16

What's Changed

• Exhaustive MySQL Parser by @adamziel and @JanJakes in #157
• Fix datetime field with empty default by @wojtekn in #166
• Fix unlimited key lengths issue by @wojtekn in #168
• Exclude .github directory for export, unify wp-includes paths by @JanJakes in #172

New Contributors

• @wojtekn made their first contribution in #166

Full Changelog: v2.1.15...v2.1.16

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