Bug #73068 [NEW]: Update buldle sqlite lib for severe bug.

From: Date: Mon, 12 Sep 2016 23:38:30 +0000
Subject: Bug #73068 [NEW]: Update buldle sqlite lib for severe bug.
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-203988@lists.php.net to get a copy of this message
From: alejosimon at gmail dot com Operating system: Windows 7 x64 PHP version: Irrelevant Package: PDO SQLite Bug Type: Bug Bug description:Update buldle sqlite lib for severe bug. 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 bug report at https://bugs.php.net/bug.php?id=73068&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=73068&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=73068&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=73068&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=73068&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=73068&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=73068&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=73068&r=needscript Try newer version: https://bugs.php.net/fix.php?id=73068&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=73068&r=support Expected behavior: https://bugs.php.net/fix.php?id=73068&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=73068&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=73068&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=73068&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=73068&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=73068&r=dst IIS Stability: https://bugs.php.net/fix.php?id=73068&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=73068&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=73068&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=73068&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=73068&r=mysqlcfg

« previous php.bugs (#203988) next »