Repository navigation

Issues

New issue

Advanced MySQL compatibility
#162 · JanJakes opened on Nov 4, 2024
2
Release 3.0 checklist
#467 · JanJakes opened on Jul 31, 2026
Track support for randomized storage and DB_PATH
#513 · JanJakes opened on Sep 24, 2026

Identifiers with non-ASCII characters are rejected ("The SQLite driver only supports ASCII characters in identifiers")
WordPress/sqlite-database-integration#559 · opened on Oct 22, 2026
ALTER COLUMN ... DROP DEFAULT on a nullable column is stored as DEFAULT NULL
WordPress/sqlite-database-integration#556 · opened on Oct 22, 2026
ON UPDATE CURRENT_TIMESTAMP overwrites explicit values and updates unchanged rows
WordPress/sqlite-database-integration#554 · opened on Oct 22, 2026
ALTER COLUMN with SET DEFAULT and DROP DEFAULT are ignored
WordPress/sqlite-database-integration#553 · opened on Oct 21, 2026
Non-strict INSERT stores '' instead of a '0' column default
WordPress/sqlite-database-integration#552 · opened on Oct 21, 2026
Validate and normalize literal column defaults like MySQL
WordPress/sqlite-database-integration#551 · opened on Oct 21, 2026
1
OPTIMIZE and REPAIR TABLE leave a copy of the table behind when they fail
WordPress/sqlite-database-integration#549 · opened on Oct 21, 2026
Allow configuring the SQLite busy timeout (SQLITE_BUSY_TIMEOUT)
WordPress/sqlite-database-integration#548 · opened on Oct 21, 2026
ALTER TABLE drops legacy ON UPDATE CURRENT_TIMESTAMP triggers
WordPress/sqlite-database-integration#547 · opened on Oct 21, 2026
ALTER TABLE fails when legacy BLOB columns contain TEXT values
WordPress/sqlite-database-integration#546 · opened on Oct 21, 2026
YEAR string zeros '0' and '00' are stored as 0000 instead of 2000
WordPress/sqlite-database-integration#545 · opened on Oct 21, 2026
ALTER TABLE and OPTIMIZE TABLE reset the AUTO_INCREMENT counter
WordPress/sqlite-database-integration#544 · opened on Oct 21, 2026
AST driver rejects odd-length 0x hex literals that MySQL accepts (e.g. 0x711)
WordPress/sqlite-database-integration#543 · opened on Oct 21, 2026
SHOW CREATE TABLE quotes numeric temporal defaults (DEFAULT 0 → '0'), breaking MySQL import
WordPress/sqlite-database-integration#541 · opened on Oct 19, 2026
UNHEX() binary UUID comparisons silently return no rows (breaks Staatic)
WordPress/sqlite-database-integration#538 · opened on Oct 17, 2026
1
DATE_ADD() and DATE_SUB() differ from MySQL for DATE values, month ends, and QUARTER and composite units
WordPress/sqlite-database-integration#531 · opened on Oct 13, 2026
SET autocommit and SET foreign_key_checks are accepted but have no effect
WordPress/sqlite-database-integration#529 · opened on Oct 12, 2026
ALTER TABLE on a parent table deletes child rows through ON DELETE CASCADE
WordPress/sqlite-database-integration#528 · opened on Oct 12, 2026
2
DATETIME(n) / TIMESTAMP(n) columns drop fractional seconds
WordPress/sqlite-database-integration#527 · opened on Oct 12, 2026
BIT_OR(), BIT_AND() and BIT_XOR() aggregates are not supported
WordPress/sqlite-database-integration#526 · opened on Oct 12, 2026
Match MySQL mixed-type result and comparison semantics for IF(), CASE, and IFNULL()
WordPress/sqlite-database-integration#519 · opened on Oct 6, 2026
Feature: Add some option to prevent deactivating this plugin
WordPress/sqlite-database-integration#516 · opened on Oct 3, 2026
Run SQLite storage tests on Windows
WordPress/sqlite-database-integration#515 · opened on Oct 1, 2026
Track support for randomized storage and DB_PATH
WordPress/sqlite-database-integration#513 · opened on Sep 24, 2026
Add PIE support for native extension
WordPress/sqlite-database-integration#504 · opened on Sep 6, 2026
3

Navigation Menu

Repository navigation

Issues

Issues

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

ALTER COLUMN ... DROP DEFAULT on a nullable column is stored as DEFAULT NULL

ON UPDATE CURRENT_TIMESTAMP overwrites explicit values and updates unchanged rows

`ALTER COLUMN` with `SET DEFAULT` and `DROP DEFAULT` are ignored

Non-strict INSERT stores '' instead of a '0' column default

Validate and normalize literal column defaults like MySQL

OPTIMIZE and REPAIR TABLE leave a copy of the table behind when they fail

Allow configuring the SQLite busy timeout (SQLITE_BUSY_TIMEOUT)

ALTER TABLE drops legacy ON UPDATE CURRENT_TIMESTAMP triggers

ALTER TABLE fails when legacy BLOB columns contain TEXT values

YEAR string zeros '0' and '00' are stored as 0000 instead of 2000

ALTER TABLE and OPTIMIZE TABLE reset the AUTO_INCREMENT counter

AST driver rejects odd-length 0x hex literals that MySQL accepts (e.g. 0x711)

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

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

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

SET autocommit and SET foreign_key_checks are accepted but have no effect

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

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

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

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

Feature: Add some option to prevent deactivating this plugin

Run SQLite storage tests on Windows

Track support for randomized storage and `DB_PATH`

Add PIE support for native extension