Req #73068 [Ver]: Update to SQLite 3.14.2

Edit report at https://bugs.php.net/bug.php?id=73068&edit=1 ID: 73068 Updated by: cmb@php.net Reported by: alejosimon at gmail dot com Summary: Update to SQLite 3.14.2 Status: Verified Type: Feature/Change Request Package: SQLite related Operating System: Windows 7 x64 PHP Version: Irrelevant -Assigned To: cmb +Assigned To: ab Block user comment: N Private report: N New Comment: I have updated PHP 7.1+ to SQLite 3.14.2, see <http://git.php.net/?p=php-src.git;a=commit;h=07aab07c>. Anatol, should PHP 7.0 be updated as well? Previous Comments: ------------------------------------------------------------------------ [2016-09-13 11:25:46] cmb@php.net After further consideration, I don't think this qualifies as bug, because users can compile against a custom libsqlite3. ------------------------------------------------------------------------ [2016-09-13 11:06:51] cmb@php.net I don't think that the second issue is too much of a problem, because the bug report states: > This problem has been in the code since before version 3.3.7 > (2006-08-12), and and hence gone unnoticed for over ten years. > For that reason, it is given a low severity. The first issue, however, appears to be real problem. Anyhow, SQLite 3.14.2 has already been released, so PHP 7.1+ will have to be updated anyway. PHP 5.6 is still on SQLite 3.8.10.2, and as such is not affected by the first issue. It's not yet clear to me what to do with PHP 7.0, which is still on SQLite 3.13.0. ------------------------------------------------------------------------ [2016-09-12 23:38:24] alejosimon at gmail dot com Description: ------------ In the last realease of sqlite anunce 2 important bug fixed: https://sqlite.org/src/info/ef360601 https://sqlite.org/src/info/199df4168c Especially the first one, I think that should be updated immediately for being a common use query as DELETE. Thank you, sorry for my english. Test script: --------------- <?php $db = new \PDO( 'sqlite::memory:' ) ; $db->exec( " CREATE TABLE IF NOT EXISTS t1(a INT UNIQUE, b INT); INSERT OR REPLACE INTO t1(a,b) VALUES('1','2'); SELECT * FROM t1 WHERE a='1' AND b='2'; DELETE FROM t1 WHERE a='1' AND b='2'; " ); print_r( $db->query( "SELECT * FROM t1;" )->fetchAll() ); ?> Expected result: ---------------- Array ( ) Actual result: -------------- Array ( [0] => Array ( [a] => 1 [0] => 1 [b] => 2 [1] => 2 ) ) ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=73068&edit=1