xref: /sqlite-3.40.0/test/tkt-78e04e52ea.test (revision 8210233c) 
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
16set testdir [file dirname $argv0]
17source $testdir/tester.tcl
18
19do_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}
28do_test tkt-78e04-1.1 {
29  catchsql {
30    INSERT INTO ""("") VALUES(1);
31  }
32} {1 {UNIQUE constraint failed: .}}
33do_test tkt-78e04-1.2 {
34  execsql {
35    PRAGMA table_info("");
36  }
37} {0 {} {} 0 {} 0 1 x CHAR(100) 0 {} 0}
38do_test tkt-78e04-1.3 {
39  execsql {
40    CREATE INDEX i1 ON ""("" COLLATE nocase);
41  }
42} {}
43do_test tkt-78e04-1.4 {
44 db eval {EXPLAIN QUERY PLAN SELECT "" FROM "" WHERE "" LIKE '1e5%';}
45} {/*SCAN  USING COVERING INDEX i1*/}
46do_test tkt-78e04-1.5 {
47  execsql {
48    DROP TABLE "";
49    SELECT name FROM sqlite_master;
50  }
51} {t2}
52
53do_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=?)*/}
59do_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
66finish_test
67