Bug #73068 [Opn->Ver]: SQLite3 may fail to DELETE

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 buldle sqlite lib for severe bug. +Summary: SQLite3 may fail to DELETE -Status: Open +Status: Verified Type: Bug -Package: PDO SQLite +Package: SQLite related Operating System: Windows 7 x64 PHP Version: Irrelevant -Assigned To: +Assigned To: cmb Block user comment: N Private report: N New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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