diff options
author | Anatol Belski <ab@php.net> | 2016-09-13 15:29:46 +0200 |
---|---|---|
committer | Anatol Belski <ab@php.net> | 2016-09-13 15:29:46 +0200 |
commit | 5163925796790e66edd6abbf1a437e1e50deeb8b (patch) | |
tree | 8abf1a5d61d74cb3eca83b3d7e44f4de530cfaeb | |
parent | 941b56dd4a1da83c19d0fc8e99fd0c7fc6feed21 (diff) | |
parent | 248f8c3a91ce28d2d7b1096e6b381ba9029896db (diff) | |
download | php-git-5163925796790e66edd6abbf1a437e1e50deeb8b.tar.gz |
Merge branch 'PHP-5.6' into PHP-7.0
* PHP-5.6:
add test for bug #73068
-rw-r--r-- | ext/sqlite3/tests/bug73068.phpt | 37 |
1 files changed, 37 insertions, 0 deletions
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-- +<?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> +--FILE-- +<?php + +$db = new \SQLite3(':memory:') ; + +$db->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== |