Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Newer
Older
100644 88 lines (78 sloc) 2.154 kB
7b63a4e @sjlombardo track 3.7.0
sjlombardo authored
1 # 2010 June 09
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
14 set testdir [file dirname $argv0]
15 source $testdir/tester.tcl
16
17 do_test tkt-f973c7ac3-1.0 {
18 execsql {
19 CREATE TABLE t(c1 INTEGER, c2 INTEGER);
20 INSERT INTO t VALUES(5, 5);
21 INSERT INTO t VALUES(5, 4);
22 }
23 } {}
24
25 foreach {tn sql} {
26 1 ""
27 2 "CREATE INDEX i1 ON t(c1, c2)"
28 } {
29
30 execsql $sql
31
32 do_test tkt-f973c7ac3-1.$tn.1 {
33 execsql {
34 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<='2' ORDER BY c2 DESC
35 }
36 } {}
37 do_test tkt-f973c7ac3-1.$tn.2 {
38 execsql {
39 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<=5 ORDER BY c2 DESC
40 }
41 } {5 5 5 4}
42 do_test tkt-f973c7ac3-1.$tn.3 {
43 execsql {
44 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<='5' ORDER BY c2 DESC
45 }
46 } {5 5 5 4}
47 do_test tkt-f973c7ac3-1.$tn.4 {
48 execsql {
49 SELECT * FROM t WHERE c1 = 5 AND c2>'0' AND c2<=5 ORDER BY c2 DESC
50 }
51 } {5 5 5 4}
52 do_test tkt-f973c7ac3-1.$tn.5 {
53 execsql {
54 SELECT * FROM t WHERE c1 = 5 AND c2>'0' AND c2<='5' ORDER BY c2 DESC
55 }
56 } {5 5 5 4}
57
58 do_test tkt-f973c7ac3-1.$tn.6 {
59 execsql {
60 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<='2' ORDER BY c2 ASC
61 }
62 } {}
63 do_test tkt-f973c7ac3-1.$tn.7 {
64 execsql {
65 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<=5 ORDER BY c2 ASC
66 }
67 } {5 4 5 5}
68 do_test tkt-f973c7ac3-1.$tn.8 {
69 execsql {
70 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<='5' ORDER BY c2 ASC
71 }
72 } {5 4 5 5}
73 do_test tkt-f973c7ac3-1.$tn.9 {
74 execsql {
75 SELECT * FROM t WHERE c1 = 5 AND c2>'0' AND c2<=5 ORDER BY c2 ASC
76 }
77 } {5 4 5 5}
78 do_test tkt-f973c7ac3-1.$tn.10 {
79 execsql {
80 SELECT * FROM t WHERE c1 = 5 AND c2>'0' AND c2<='5' ORDER BY c2 ASC
81 }
82 } {5 4 5 5}
83 }
84
85
86 finish_test
87
Something went wrong with that request. Please try again.