sqlite3_defensive.phpt fails with sqlite 3.44.0

Description

The ext/sqlite3/tests/sqlite3_defensive.phpt test started to fail after upgrade of SQLite to 3.44.0 on all arches

Resulted in this output:

TEST 12220/16282 [ext/sqlite3/tests/sqlite3_defensive.phpt]
========DIFF========
     bool(true)
003+ int(0)
     int(1)
004- int(1)
     
     Warning: SQLite3::querySingle(): Unable to prepare statement: 1, table sqlite_master may not be modified in %s on line %d
     bool(false)

PHP Version

PHP 8.1.25 and later

Operating System

Alpinelinux

I'll see this later.

Probably due to this change. It looks like the test needs to be modified.

The SQLITE_DBCONFIG_DEFENSIVE setting now prevents PRAGMA writable_schema from being turned on. Previously writable_schema could be turned on, but would not actually allow the schema to be writable. Now it simply cannot be turned on.

https://www.sqlite.org/releaselog/3_44_0.html

Fix GH-12633: sqlite3_defensive.phpt fails with sqlite 3.44.0

Merge branch 'PHP-8.1' into PHP-8.2

Merge branch 'PHP-8.2' into PHP-8.3

Merge branch 'PHP-8.3'

Navigation Menu

Repository navigation

sqlite3_defensive.phpt fails with sqlite 3.44.0 #12633

Description

PHP Version

Operating System

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

sqlite3_defensive.phpt fails with sqlite 3.44.0 #12633

Description

Description

PHP Version

Operating System

Activity

SakiTakamachi commented on Nov 8, 2023

SakiTakamachi commented on Nov 8, 2023

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions