xref: /PHP-7.2/ext/sqlite3/tests/bug73068.phpt (revision 248f8c3a)
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