diff options
author | Anatol Belski <ab@php.net> | 2016-09-13 15:28:28 +0200 |
---|---|---|
committer | Anatol Belski <ab@php.net> | 2016-09-13 15:28:28 +0200 |
commit | 248f8c3a91ce28d2d7b1096e6b381ba9029896db (patch) | |
tree | 61264adb15b7c5838cf46108c27f175dd2c85d05 /ext/sqlite3 | |
parent | fc31d6fed4ce4e58bf46204a31d4441684722c81 (diff) | |
download | php-git-248f8c3a91ce28d2d7b1096e6b381ba9029896db.tar.gz |
add test for bug #73068
Diffstat (limited to 'ext/sqlite3')
-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== |