Debian Codegraph @

test/tkt-78e04e52ea.test

raw
1 # 2009 December 8
2 #
3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
5 #
6 # May you do good and not evil.
7 # May you find forgiveness for yourself and forgive others.
8 # May you share freely, never taking more than you give.
9 #
10 #***********************************************************************
11 # This file implements regression tests for SQLite library.
12 #
13 # Verify that we can create zero-length tables.
14 #
15
16 set testdir [file dirname $argv0]
17 source $testdir/tester.tcl
18
19 do_test tkt-78e04-1.0 {
20 execsql {
21 CREATE TABLE ""("" UNIQUE, x CHAR(100));
22 CREATE TABLE t2(x);
23 INSERT INTO ""("") VALUES(1);
24 INSERT INTO t2 VALUES(2);
25 SELECT * FROM "", t2;
26 }
27 } {1 {} 2}
28 do_test tkt-78e04-1.1 {
29 catchsql {
30 INSERT INTO ""("") VALUES(1);
31 }
32 } {1 {UNIQUE constraint failed: .}}
33 do_test tkt-78e04-1.2 {
34 execsql {
35 PRAGMA table_info("");
36 }
37 } {0 {} {} 0 {} 0 1 x CHAR(100) 0 {} 0}
38 do_test tkt-78e04-1.3 {
39 execsql {
40 CREATE INDEX i1 ON ""("" COLLATE nocase);
41 }
42 } {}
43 do_test tkt-78e04-1.4 {
44 db eval {EXPLAIN QUERY PLAN SELECT "" FROM "" WHERE "" LIKE '1e5%';}
45 } {/*SCAN USING COVERING INDEX i1*/}
46 do_test tkt-78e04-1.5 {
47 execsql {
48 DROP TABLE "";
49 SELECT name FROM sqlite_master;
50 }
51 } {t2}
52
53 do_test tkt-78e04-2.1 {
54 execsql {
55 CREATE INDEX "" ON t2(x);
56 EXPLAIN QUERY PLAN SELECT * FROM t2 WHERE x=5;
57 }
58 } {/*SEARCH t2 USING COVERING INDEX (x=?)*/}
59 do_test tkt-78e04-2.2 {
60 execsql {
61 DROP INDEX "";
62 EXPLAIN QUERY PLAN SELECT * FROM t2 WHERE x=2;
63 }
64 } {/*SCAN t2*/}
65
66 finish_test