diff options
author | Anatol Belski <ab@php.net> | 2016-09-13 15:30:35 +0200 |
---|---|---|
committer | Anatol Belski <ab@php.net> | 2016-09-13 15:30:35 +0200 |
commit | 86d6f29e8f763cfa25e966c67699e225e52586f6 (patch) | |
tree | e22aa26daa7db9e40a6f509e0d2b60064081afb9 | |
parent | 07aab07ce5faec29606d846c9df33296e2a33d48 (diff) | |
parent | 5163925796790e66edd6abbf1a437e1e50deeb8b (diff) | |
download | php-git-86d6f29e8f763cfa25e966c67699e225e52586f6.tar.gz |
Merge branch 'PHP-7.0' into PHP-7.1
* PHP-7.0:
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== |