diff options
Diffstat (limited to 'ext/sqlite/tests/sqlite_019.phpt')
-rwxr-xr-x | ext/sqlite/tests/sqlite_019.phpt | 47 |
1 files changed, 0 insertions, 47 deletions
diff --git a/ext/sqlite/tests/sqlite_019.phpt b/ext/sqlite/tests/sqlite_019.phpt deleted file mode 100755 index 74dcff99fa..0000000000 --- a/ext/sqlite/tests/sqlite_019.phpt +++ /dev/null @@ -1,47 +0,0 @@ ---TEST-- -sqlite: single query ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -sqlite_query($db, "CREATE TABLE test_db ( id INTEGER PRIMARY KEY, data VARCHAR(100) )"); -for ($i = 0; $i < 10; $i++) { - sqlite_query($db, "INSERT INTO test_db (data) VALUES('{$i}data')"); -} -sqlite_query($db, "INSERT INTO test_db (data) VALUES(NULL)"); - -var_dump(sqlite_single_query($db, "SELECT id FROM test_db WHERE id=5")); -var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id=4")); -var_dump(sqlite_single_query($db, "SELECT data FROM test_db WHERE id=6")); -var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id < 5")); -var_dump(sqlite_single_query($db, "SELECT * FROM test db WHERE id < 4")); -var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id=999999")); -var_dump(sqlite_single_query($db, "SELECT id FROM test_db WHERE id=5", FALSE)); - -sqlite_close($db); -?> ---EXPECTF-- -string(1) "5" -string(1) "4" -string(5) "5data" -array(4) { - [0]=> - string(1) "1" - [1]=> - string(1) "2" - [2]=> - string(1) "3" - [3]=> - string(1) "4" -} - -Warning: sqlite_single_query(): no such table: test in %s on line %d -bool(false) -NULL -array(1) { - [0]=> - string(1) "5" -} |