wasCSharpSQLite – Blame information for rev 1

Subversion Repositories:
Rev:
Rev Author Line No. Line
1 office 1 #
2 # 2008 January 20
3 #
4 # The author disclaims copyright to this source code. In place of
5 # a legal notice, here is a blessing:
6 #
7 # May you do good and not evil.
8 # May you find forgiveness for yourself and forgive others.
9 # May you share freely, never taking more than you give.
10 #
11 #***********************************************************************
12 # This file implements regression tests for SQLite library. The
13 # focus of this script is the built-in RTRIM collating
14 # API.
15 #
16 # $Id: collateA.test,v 1.3 2008/04/15 04:02:41 drh Exp $
17  
18 set testdir [file dirname $argv0]
19 source $testdir/tester.tcl
20  
21 do_test collateA-1.1 {
22 execsql {
23 CREATE TABLE t1(
24 a INTEGER PRIMARY KEY,
25 b TEXT COLLATE BINARY,
26 c TEXT COLLATE RTRIM
27 );
28 INSERT INTO t1 VALUES(1, 'abcde','abcde');
29 INSERT INTO t1 VALUES(2, 'xyzzy ','xyzzy ');
30 INSERT INTO t1 VALUES(3, 'xyzzy ','xyzzy ');
31 INSERT INTO t1 VALUES(4, 'xyzzy ','xyzzy ');
32 INSERT INTO t1 VALUES(5, ' ', ' ');
33 INSERT INTO t1 VALUES(6, '', '');
34 SELECT count(*) FROM t1;
35 }
36 } {6}
37 do_test collateA-1.2 {
38 execsql {SELECT a FROM t1 WHERE b='abcde '}
39 } {}
40 do_test collateA-1.3 {
41 execsql {SELECT a FROM t1 WHERE c='abcde '}
42 } {1}
43 do_test collateA-1.4 {
44 execsql {SELECT a FROM t1 WHERE b='xyzzy'}
45 } {}
46 do_test collateA-1.5 {
47 execsql {SELECT a FROM t1 WHERE c='xyzzy'}
48 } {2 3 4}
49 do_test collateA-1.6 {
50 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
51 } {2 3 4}
52 do_test collateA-1.7 {
53 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
54 } {2 3 4}
55 do_test collateA-1.8 {
56 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
57 } {2 3 4}
58 do_test collateA-1.9 {
59 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
60 } {2 3 4}
61 do_test collateA-1.10 {
62 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
63 } {2 3 4}
64 do_test collateA-1.11 {
65 execsql {SELECT 'abc123'='abc123 ' COLLATE RTRIM;}
66 } {1}
67 do_test collateA-1.12 {
68 execsql {SELECT 'abc123 '='abc123' COLLATE RTRIM;}
69 } {1}
70 do_test collateA-1.13 {
71 execsql {SELECT ' '='' COLLATE RTRIM, ' '='' COLLATE BINARY, ' '=''}
72 } {1 0 0}
73 do_test collateA-1.14 {
74 execsql {SELECT ''=' ' COLLATE RTRIM, ''=' ' COLLATE BINARY, ''=' '}
75 } {1 0 0}
76 do_test collateA-1.15 {
77 execsql {SELECT ' '=' ' COLLATE RTRIM, ' '=' '}
78 } {1 0}
79 do_test collateA-1.16 {
80 execsql {SELECT ''<>' ' COLLATE RTRIM, ''<>' ' COLLATE BINARY, ''<>' '}
81 } {0 1 1}
82 do_test collateA-1.17 {
83 execsql {SELECT a FROM t1 WHERE c='xyzz'}
84 } {}
85 do_test collateA-1.18 {
86 execsql {SELECT a FROM t1 WHERE c='xyzzyy '}
87 } {}
88 do_test collateA-1.19 {
89 execsql {SELECT a FROM t1 WHERE c='xyzz '}
90 } {}
91 do_test collateA-1.20 {
92 execsql {SELECT a FROM t1 WHERE c='abcd '}
93 } {}
94 do_test collateA-1.21 {
95 execsql {SELECT a FROM t1 WHERE c='abcd'}
96 } {}
97 do_test collateA-1.22 {
98 execsql {SELECT a FROM t1 WHERE c='abc'}
99 } {}
100 do_test collateA-1.23 {
101 execsql {SELECT a FROM t1 WHERE c='abcdef '}
102 } {}
103 do_test collateA-1.24 {
104 execsql {SELECT a FROM t1 WHERE c=''}
105 } {5 6}
106 do_test collateA-1.25 {
107 execsql {SELECT a FROM t1 WHERE c=' '}
108 } {5 6}
109 do_test collateA-1.26 {
110 execsql {SELECT a FROM t1 WHERE c=' '}
111 } {5 6}
112  
113  
114 do_test collateA-2.1 {
115 execsql {
116 CREATE INDEX i1b ON t1(b);
117 CREATE INDEX i1c ON t1(c);
118 PRAGMA integrity_check;
119 }
120 } {ok}
121 do_test collateA-2.2 {
122 execsql {SELECT a FROM t1 WHERE b='abcde '}
123 } {}
124 do_test collateA-2.3 {
125 execsql {SELECT a FROM t1 WHERE c='abcde '}
126 } {1}
127 do_test collateA-2.4 {
128 execsql {SELECT a FROM t1 WHERE b='xyzzy'}
129 } {}
130 do_test collateA-2.5 {
131 execsql {SELECT a FROM t1 WHERE c='xyzzy'}
132 } {2 3 4}
133 do_test collateA-2.6 {
134 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
135 } {2 3 4}
136 do_test collateA-2.7 {
137 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
138 } {2 3 4}
139 do_test collateA-2.8 {
140 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
141 } {2 3 4}
142 do_test collateA-2.9 {
143 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
144 } {2 3 4}
145 do_test collateA-2.10 {
146 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
147 } {2 3 4}
148 do_test collateA-2.17 {
149 execsql {SELECT a FROM t1 WHERE c='xyzz'}
150 } {}
151 do_test collateA-2.18 {
152 execsql {SELECT a FROM t1 WHERE c='xyzzyy '}
153 } {}
154 do_test collateA-2.19 {
155 execsql {SELECT a FROM t1 WHERE c='xyzz '}
156 } {}
157 do_test collateA-2.20 {
158 execsql {SELECT a FROM t1 WHERE c='abcd '}
159 } {}
160 do_test collateA-2.21 {
161 execsql {SELECT a FROM t1 WHERE c='abcd'}
162 } {}
163 do_test collateA-2.22 {
164 execsql {SELECT a FROM t1 WHERE c='abc'}
165 } {}
166 do_test collateA-2.23 {
167 execsql {SELECT a FROM t1 WHERE c='abcdef '}
168 } {}
169 do_test collateA-2.24 {
170 execsql {SELECT a FROM t1 WHERE c=''}
171 } {5 6}
172 do_test collateA-2.25 {
173 execsql {SELECT a FROM t1 WHERE c=' '}
174 } {5 6}
175 do_test collateA-2.26 {
176 execsql {SELECT a FROM t1 WHERE c=' '}
177 } {5 6}
178  
179  
180 do_test collateA-3.1 {
181 db close
182 sqlite3 db test.db
183 execsql {
184 REINDEX;
185 PRAGMA integrity_check;
186 }
187 } {ok}
188 do_test collateA-3.2 {
189 execsql {SELECT a FROM t1 WHERE b='abcde '}
190 } {}
191 do_test collateA-3.3 {
192 execsql {SELECT a FROM t1 WHERE c='abcde '}
193 } {1}
194 do_test collateA-3.4 {
195 execsql {SELECT a FROM t1 WHERE b='xyzzy'}
196 } {}
197 do_test collateA-3.5 {
198 execsql {SELECT a FROM t1 WHERE c='xyzzy'}
199 } {2 3 4}
200 do_test collateA-3.6 {
201 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
202 } {2 3 4}
203 do_test collateA-3.7 {
204 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
205 } {2 3 4}
206 do_test collateA-3.8 {
207 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
208 } {2 3 4}
209 do_test collateA-3.9 {
210 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
211 } {2 3 4}
212 do_test collateA-3.10 {
213 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
214 } {2 3 4}
215  
216  
217 finish_test