From 248f8c3a91ce28d2d7b1096e6b381ba9029896db Mon Sep 17 00:00:00 2001 From: Anatol Belski Date: Tue, 13 Sep 2016 15:28:28 +0200 Subject: add test for bug #73068 --- ext/sqlite3/tests/bug73068.phpt | 37 +++++++++++++++++++++++++++++++++++++ 1 file changed, 37 insertions(+) create mode 100644 ext/sqlite3/tests/bug73068.phpt diff --git a/ext/sqlite3/tests/bug73068.phpt b/ext/sqlite3/tests/bug73068.phpt new file mode 100644 index 0000000000..f3a05d7f80 --- /dev/null +++ b/ext/sqlite3/tests/bug73068.phpt @@ -0,0 +1,37 @@ +--TEST-- +Bug #73068 SQLite3 may fail to DELETE +--SKIPIF-- + +--FILE-- +exec("CREATE TABLE IF NOT EXISTS t1(a INT UNIQUE, b INT)"); +$db->exec("INSERT OR REPLACE INTO t1(a,b) VALUES('1','2')"); + +$r = $db->query("SELECT * FROM t1 WHERE a='1' AND b='2'"); +var_dump($r->fetchArray()); + +$db->exec("DELETE FROM t1 WHERE a='1' AND b='2'"); + +$r = $db->query("SELECT * FROM t1;"); +var_dump($r->fetchArray()); + +$db->close(); + +?> +==OK== +--EXPECT-- +array(4) { + [0]=> + int(1) + ["a"]=> + int(1) + [1]=> + int(2) + ["b"]=> + int(2) +} +bool(false) +==OK== -- cgit v1.2.1