Issues

• SHOW CREATE TABLE quotes numeric temporal defaults (DEFAULT 0 → '0'), breaking MySQL import

  WordPress/sqlite-database-integration#541 · Filter by author chubes4 opened on Oct 19, 2026

• UNHEX() binary UUID comparisons silently return no rows (breaks Staatic)

  WordPress/sqlite-database-integration#538 · Filter by author arashb31 opened on Oct 17, 2026

• DATE_ADD() and DATE_SUB() differ from MySQL for DATE values, month ends, and QUARTER and composite units

  WordPress/sqlite-database-integration#531 · Filter by author Nandan108 opened on Oct 13, 2026

• SET autocommit and SET foreign_key_checks are accepted but have no effect

  WordPress/sqlite-database-integration#529 · Filter by author Nandan108 opened on Oct 12, 2026

• ALTER TABLE on a parent table deletes child rows through ON DELETE CASCADE

  WordPress/sqlite-database-integration#528 · Filter by author Nandan108 opened on Oct 12, 2026
  1

• DATETIME(n) / TIMESTAMP(n) columns drop fractional seconds

  WordPress/sqlite-database-integration#527 · Filter by author Nandan108 opened on Oct 12, 2026

• BIT_OR(), BIT_AND() and BIT_XOR() aggregates are not supported

  WordPress/sqlite-database-integration#526 · Filter by author Nandan108 opened on Oct 12, 2026

• Match MySQL mixed-type result and comparison semantics for IF(), CASE, and IFNULL()

  WordPress/sqlite-database-integration#519 · Filter by author coderabbitai opened on Oct 6, 2026
  

• Feature: Add some option to prevent deactivating this plugin

  WordPress/sqlite-database-integration#516 · Filter by author nickchomey opened on Oct 3, 2026

• Run SQLite storage tests on Windows

  WordPress/sqlite-database-integration#515 · Filter by author JanJakes opened on Oct 1, 2026

• Track support for randomized storage and DB_PATH

  WordPress/sqlite-database-integration#513 · Filter by author JanJakes opened on Sep 24, 2026

• Add PIE support for native extension

  WordPress/sqlite-database-integration#504 · Filter by author nickchomey opened on Sep 6, 2026
  3

• FYI: I created an issue to get the native extension added to Static PHP, such that it can be used in things like FrankenPHP

  WordPress/sqlite-database-integration#503 · Filter by author nickchomey opened on Sep 4, 2026

• DATE_FORMAT() translation is incorrect for most MySQL format specifiers, silently breaking WP_Date_Query time queries

  bug
  WordPress/sqlite-database-integration#491 · Filter by author swissspidy opened on Aug 17, 2026

• On 3.0.0 rc8, plugin folder path mismatching?

  WordPress/sqlite-database-integration#478 · Filter by author teolaz opened on Aug 6, 2026
  2

• Honor PDO::ATTR_CASE and PDO::ATTR_ORACLE_NULLS without affecting internal queries

  WordPress/sqlite-database-integration#475 · Filter by author JanJakes opened on Aug 5, 2026

• Match PDO MySQL lastInsertId() behavior in edge cases

  WordPress/sqlite-database-integration#474 · Filter by author JanJakes opened on Aug 5, 2026

• Align PDO error handling and diagnostics with PDO MySQL

  WordPress/sqlite-database-integration#473 · Filter by author JanJakes opened on Aug 5, 2026

• Track removal of the deprecated WP_SQLite_Driver API

  WordPress/sqlite-database-integration#457 · Filter by author JanJakes opened on Jul 27, 2026
  1

• Charset and collation support

  WordPress/sqlite-database-integration#456 · Filter by author JanJakes opened on Jul 27, 2026

• MySQL-on-SQLite lacks geo query function compatibility

  WordPress/sqlite-database-integration#455 · Filter by author chubes4 opened on Jul 20, 2026
  2

• MySQL-on-SQLite does not translate DATE arithmetic with INTERVAL HOUR

  WordPress/sqlite-database-integration#454 · Filter by author chubes4 opened on Jul 20, 2026
  3

• DB issue when using mailpoet

  WordPress/sqlite-database-integration#422 · Filter by author plus8 opened on Jun 2, 2026
  2

• Emulate UNSIGNED integer semantics for CAST and CONVERT

  WordPress/sqlite-database-integration#359 · Filter by author JanJakes opened on Apr 10, 2026

• Address remaining WordPress PHPUnit test failures

  WordPress/sqlite-database-integration#320 · Filter by author JanJakes opened on Feb 13, 2026
  1