1--TEST-- 2Bug #73068 SQLite3 may fail to DELETE 3--SKIPIF-- 4<?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> 5--FILE-- 6<?php 7 8$db = new \SQLite3(':memory:') ; 9 10$db->exec("CREATE TABLE IF NOT EXISTS t1(a INT UNIQUE, b INT)"); 11$db->exec("INSERT OR REPLACE INTO t1(a,b) VALUES('1','2')"); 12 13$r = $db->query("SELECT * FROM t1 WHERE a='1' AND b='2'"); 14var_dump($r->fetchArray()); 15 16$db->exec("DELETE FROM t1 WHERE a='1' AND b='2'"); 17 18$r = $db->query("SELECT * FROM t1;"); 19var_dump($r->fetchArray()); 20 21$db->close(); 22 23?> 24==OK== 25--EXPECT-- 26array(4) { 27 [0]=> 28 int(1) 29 ["a"]=> 30 int(1) 31 [1]=> 32 int(2) 33 ["b"]=> 34 int(2) 35} 36bool(false) 37==OK== 38
