Stdlib: SQLite3::open/backup/createAggregate/createCollation/loadExtension/version/lastError* still missing after #19862 (ext/sqlite3/sqlite3.stub.php)

[PurHur]

Category

stdlib · php-src-strict · ext/sqlite3 · pillar 4

Problem

#19862 / #19821 restored query/prepare/createFunction/busyTimeout/enableExceptions, but several stub methods remain unregistered. Apps that reopen DBs via open(), use aggregates/collations, backup, load extensions, or read lastError* still fatal.

Verified 2026-07-18 (PHP_COMPILER_PROFILE=8.4, VM) — get_class_methods(SQLite3):

Present: __construct, close, query, exec, prepare, createFunction, enableExceptions, busyTimeout, lastInsertRowID, changes, escapeString, querySingle

Missing vs php-src stub:

Method	php-src	VM
open	present	missing
createAggregate	present	missing
createCollation	present	missing
backup	present	missing
loadExtension	present	missing
version (static)	present	missing
totalChanges	present	missing
lastErrorCode / lastErrorMsg	present	missing

$db = new SQLite3(':memory:');
$db->open(':memory:'); // Error: Call to undefined method SQLite3::open()

php-src reference

• php/php-src ext/sqlite3/sqlite3.stub.php — class SQLite3 method list
• php/php-src ext/sqlite3/sqlite3.c — SQLITE3_METHOD(open|backup|createAggregate|…)

PHP implementation target

• ext/sqlite3/ PHP-in-PHP handlers mirroring existing createFunction / query patterns
• open can share construct/open path; lastError* read from connection state already tracked for exec failures
• No new runtime/*.c

Repro

./script/docker-exec.sh -- bash -lc 'source script/php-env.sh && PHP_COMPILER_PROFILE=8.4 php bin/vm.php -r "
foreach ([\"open\",\"backup\",\"createAggregate\",\"createCollation\",\"loadExtension\",\"version\",\"totalChanges\",\"lastErrorCode\",\"lastErrorMsg\",\"createFunction\"] as \$m) {
  echo \$m, \": \", method_exists(SQLite3::class, \$m) ? \"yes\" : \"NO\", PHP_EOL;
}
"'

Done when

• open, lastErrorCode, lastErrorMsg, totalChanges, version registered and match Zend semantics on happy path
• createAggregate or createCollation implemented (other may be follow-up)
• backup and/or loadExtension implemented or split follow-up issue
• Compliance/repro guard; php-src-strict; no new C

Related

• Stdlib: SQLite3 createFunction/busyTimeout/enableExceptions missing (ext/sqlite3/sqlite3.c) #19862 · Stdlib: SQLite3Stmt bindParam/getSQL/readOnly + Result columnType after step (ext/sqlite3/php_sqlite3.c) #19854 · Stdlib: ext/sqlite3 — SQLite3 class connect/exec/query (ext/sqlite3 parity) #3434 · Strategic alignment: compiler excellence pillars (2026 H2) #10533 pillar 4

[PurHur]

claim: PHP Compiler STD Lib — starting this run

Trust probe (this workspace):

• docker info OK; vendor present
• php script/bootstrap-inventory.php --check → OK 5679/5679
• ./script/release-readiness.sh --json → user_release_ready: yes (inventory, spine, north-star5-fast, vm-driver-probe all ok)

Scope this run: open, lastErrorCode/lastErrorMsg, version (static), plus createCollation and backup (php-src-strict). Note: Zend 8.4/8.5 has no SQLite3::totalChanges() — treating that row as issue-doc drift vs php-src stub.

[PurHur]

Merged: #20577

Verification:

• VM repro test/repro/sqlite3_open_error_version_backup.php → ok under PHP_COMPILER_PROFILE=8.4
• AOT advertise probe: method_exists for open/lastError*/version/createCollation/backup all Y under phpc build
• PHPUnit --filter sqlite3_open_error_version_backup → OK (2)
• inventory --check → OK 5685/5685

Note: Zend has no totalChanges(); left out. Instance method execution under AOT remains a pre-existing SQLite3 gap (same as exec); advertisement is AOT-green.