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
, andAS
. - 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
andUNION ALL
operators. - Advanced support for
SHOW
andDESCRIBE
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
andSTRICT_ALL_TABLES
SQL modes. - Support for
NO_BACKSLASH_ESCAPES
SQL mode. - Support for
USE <database>
statement for the main database andINFORMATION_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.
- The new driver can be enabled using
Full Changelog: v2.1.16...v2.2.0