Issues

• Function coverage audit: missing MySQL/MariaDB functions, translator gaps, and silent wrong-result bugs

  WordPress/sqlite-database-integration#586 · Filter by author nickchomey opened on Oct 30, 2026
  2

• Multi-table DELETE with LEFT JOIN fails when some rows have no match

  WordPress/sqlite-database-integration#585 · Filter by author valentin-anamorphik opened on Oct 29, 2026

• MySQL SUBSTRING_INDEX() queries fail under SQLite

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

• Feature: FULLTEXT / MATCH ... AGAINST support

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

• A failed PDO::commit() keeps the transaction open, unlike MySQL

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

• Hex literals return wrong results in numeric context and text comparisons

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

• Malformed queries trigger PHP warnings in the parser

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

• Share MySQL value conversion between INSERT and table rebuilds

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

• MySQL JSON_UNQUOTE() and JSON_CONTAINS() are not translated ("no such function")

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

• _helper_like_to_glob_pattern(): patterns containing a literal [ are mis-translated to GLOB, producing both false-positive and false-negative rows vs. MySQL LIKE

  WordPress/sqlite-database-integration#568 · Filter by author arthurrgg8-lgtm opened on Oct 24, 2026

• Ignore inline REFERENCES clauses to match MySQL

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

• Fix inline PRIMARY KEY and UNIQUE parsing and metadata

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

• Preserve and enforce inline CHECK constraints

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

• Identifiers with non-ASCII characters are rejected ("The SQLite driver only supports ASCII characters in identifiers")

  WordPress/sqlite-database-integration#559 · Filter by author ingipingi opened on Oct 22, 2026

• ALTER COLUMN ... DROP DEFAULT incorrectly sets DEFAULT NULL on nullable columns

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

• Validate and normalize literal column defaults like MySQL

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

• YEAR values '0' and '00' are stored as 0000 instead of 2000

  WordPress/sqlite-database-integration#545 · Filter by author JanJakes opened on Oct 21, 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
  1

• DATE_ADD() and DATE_SUB() overflow past the end of the month, and ADDDATE() and SUBDATE() are not supported

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

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

• 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