Lines Matching refs:a
5 # a legal notice, here is a blessing:
21 proc text_collate {a b} {
22 return [string compare $a $b]
33 # for the SQL and appends a "nosort" to the result if the program contains the
66 # Tests named collate4-1.1.* use indices with a single column. Tests
71 CREATE TABLE collate4t1(a COLLATE NOCASE, b COLLATE TEXT);
72 INSERT INTO collate4t1 VALUES( 'a', 'a' );
77 CREATE INDEX collate4i1 ON collate4t1(a);
82 cksort {SELECT a FROM collate4t1 ORDER BY a}
83 } {{} a A b B nosort}
85 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE NOCASE}
86 } {{} a A b B nosort}
88 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE TEXT}
89 } {{} A B a b sort}
92 } {{} A B a b nosort}
95 } {{} A B a b nosort}
98 } {{} a A b B sort}
103 a PRIMARY KEY COLLATE NOCASE,
106 INSERT INTO collate4t2 VALUES( 'a', 'a' );
112 cksort {SELECT a FROM collate4t2 ORDER BY a}
113 } {{} a B nosort}
115 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE NOCASE}
116 } {{} a B nosort}
118 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE TEXT}
119 } {{} B a sort}
122 } {{} B a nosort}
125 } {{} B a nosort}
128 } {{} a B sort}
134 a COLLATE NOCASE,
135 UNIQUE(a), PRIMARY KEY(b)
137 INSERT INTO collate4t3 VALUES( 'a', 'a' );
143 cksort {SELECT a FROM collate4t3 ORDER BY a}
144 } {{} a B nosort}
146 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE NOCASE}
147 } {{} a B nosort}
149 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE TEXT}
150 } {{} B a sort}
153 } {{} B a nosort}
156 } {{} B a nosort}
159 } {{} a B sort}
163 CREATE TABLE collate4t4(a COLLATE NOCASE, b COLLATE TEXT);
164 INSERT INTO collate4t4 VALUES( 'a', 'a' );
169 CREATE INDEX collate4i3 ON collate4t4(a COLLATE TEXT);
174 cksort {SELECT a FROM collate4t4 ORDER BY a, rowid}
175 } {{} a A b B sort}
177 cksort {SELECT a FROM collate4t4 ORDER BY a COLLATE NOCASE, rowid}
178 } {{} a A b B sort}
180 cksort {SELECT a FROM collate4t4 ORDER BY a COLLATE TEXT, rowid}
181 } {{} A B a b nosort}
184 } {{} A B a b sort}
187 } {{} A B a b sort}
190 } {{} a A b B nosort}
203 CREATE TABLE collate4t1(a COLLATE NOCASE, b COLLATE TEXT);
204 INSERT INTO collate4t1 VALUES( 'a', 'a' );
209 CREATE INDEX collate4i1 ON collate4t1(a, b);
213 cksort {SELECT a FROM collate4t1 ORDER BY a}
214 } {{} A a B b nosort}
216 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE nocase}
217 } {{} A a B b nosort}
219 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE text}
220 } {{} A B a b sort}
222 cksort {SELECT a FROM collate4t1 ORDER BY a, b}
223 } {{} A a B b nosort}
225 cksort {SELECT a FROM collate4t1 ORDER BY a, b COLLATE nocase, rowid}
226 } {{} a A b B sort}
228 cksort {SELECT a FROM collate4t1 ORDER BY a, b COLLATE text}
229 } {{} A a B b nosort}
234 a COLLATE NOCASE,
236 PRIMARY KEY(a, b)
238 INSERT INTO collate4t2 VALUES( 'a', 'a' );
244 cksort {SELECT a FROM collate4t2 ORDER BY a}
245 } {{} a B nosort}
247 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE nocase}
248 } {{} a B nosort}
250 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE text}
251 } {{} B a sort}
253 cksort {SELECT a FROM collate4t2 ORDER BY a, b}
254 } {{} a B nosort}
256 cksort {SELECT a FROM collate4t2 ORDER BY a, b COLLATE nocase}
257 } {{} a B sort}
259 cksort {SELECT a FROM collate4t2 ORDER BY a, b COLLATE text}
260 } {{} a B nosort}
264 CREATE TABLE collate4t3(a COLLATE NOCASE, b COLLATE TEXT);
265 INSERT INTO collate4t3 VALUES( 'a', 'a' );
270 CREATE INDEX collate4i2 ON collate4t3(a COLLATE TEXT, b COLLATE NOCASE);
274 cksort {SELECT a FROM collate4t3 ORDER BY a, rowid}
275 } {{} a A b B sort}
277 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE nocase, rowid}
278 } {{} a A b B sort}
280 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text}
281 } {{} A B a b nosort}
283 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text, b}
284 } {{} A B a b sort}
286 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text, b COLLATE nocase}
287 } {{} A B a b nosort}
289 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text, b COLLATE text}
290 } {{} A B a b sort}
292 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text DESC}
293 } {b a B A {} nosort}
295 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text DESC, b}
296 } {b a B A {} sort}
298 cksort {SELECT a FROM collate4t3
299 ORDER BY a COLLATE text DESC, b COLLATE nocase}
300 } {b a B A {} sort}
302 cksort {SELECT a FROM collate4t3
303 ORDER BY a COLLATE text DESC, b COLLATE nocase DESC}
304 } {b a B A {} nosort}
325 CREATE TABLE collate4t1(a COLLATE NOCASE);
328 INSERT INTO collate4t1 VALUES('a');
345 SELECT * FROM collate4t2, collate4t1 WHERE a = b;
347 } {A a A A 19}
350 CREATE INDEX collate4i1 ON collate4t1(a);
353 SELECT * FROM collate4t2, collate4t1 WHERE a = b;
355 } {A a A A 4}
358 SELECT * FROM collate4t2, collate4t1 WHERE b = a;
364 CREATE INDEX collate4i1 ON collate4t1(a COLLATE TEXT);
367 SELECT * FROM collate4t2, collate4t1 WHERE a = b
370 } {A a A A 19}
373 SELECT * FROM collate4t2, collate4t1 WHERE b = a;
379 SELECT a FROM collate4t1 WHERE a IN (SELECT * FROM collate4t2)
382 } {a A 10}
386 CREATE INDEX collate4i1 ON collate4t1(a);
389 SELECT a FROM collate4t1 WHERE a IN (SELECT * FROM collate4t2)
392 } {a A 5}
395 SELECT a FROM collate4t1 WHERE a IN ('z', 'a');
397 } {a A 4}
401 CREATE INDEX collate4i1 ON collate4t1(a COLLATE TEXT);
404 SELECT a FROM collate4t1 WHERE a IN ('z', 'a') ORDER BY rowid;
406 } {a A 9}
417 CREATE TABLE collate4t1(a COLLATE nocase, b COLLATE text, c);
418 CREATE TABLE collate4t2(a COLLATE nocase, b COLLATE text, c COLLATE TEXT);
438 CREATE INDEX collate4i1 ON collate4t1(a, b, c);
447 CREATE INDEX collate4i1 ON collate4t1(a, b, c COLLATE text);
468 CREATE TABLE collate4t1(a PRIMARY KEY COLLATE NOCASE);
476 } {1 {UNIQUE constraint failed: collate4t1.a}}
484 INSERT INTO collate4t1 SELECT upper(a) FROM collate4t1;
486 } {1 {UNIQUE constraint failed: collate4t1.a}}
490 UPDATE collate4t1 SET a = 'abc';
492 } {1 {UNIQUE constraint failed: collate4t1.a}}
496 CREATE TABLE collate4t1(a COLLATE NOCASE UNIQUE);
504 } {1 {UNIQUE constraint failed: collate4t1.a}}
512 INSERT INTO collate4t1 SELECT upper(a) FROM collate4t1;
514 } {1 {UNIQUE constraint failed: collate4t1.a}}
518 UPDATE collate4t1 SET a = 'abc';
520 } {1 {UNIQUE constraint failed: collate4t1.a}}
524 CREATE TABLE collate4t1(a);
525 CREATE UNIQUE INDEX collate4i1 ON collate4t1(a COLLATE NOCASE);
533 } {1 {UNIQUE constraint failed: collate4t1.a}}
541 INSERT INTO collate4t1 SELECT upper(a) FROM collate4t1;
543 } {1 {UNIQUE constraint failed: collate4t1.a}}
547 UPDATE collate4t1 SET a = 'abc';
549 } {1 {UNIQUE constraint failed: collate4t1.a}}
573 CREATE TABLE collate4t1(a COLLATE TEXT);
582 SELECT max(a) FROM collate4t1
587 SELECT min(a) FROM collate4t1
593 CREATE INDEX collate4i1 ON collate4t1(a);
596 SELECT min(a) FROM collate4t1;
601 SELECT max(a) FROM collate4t1;
608 CREATE INDEX collate4i1 ON collate4t1(a COLLATE NUMERIC);
611 SELECT min(a) FROM collate4t1;
616 SELECT max(a) FROM collate4t1;
629 CREATE TABLE collate4t1(a COLLATE TEXT, b COLLATE NUMERIC);
636 SELECT max(a, b) FROM collate4t1;
641 SELECT max(b, a) FROM collate4t1;
646 SELECT max(a, '101') FROM collate4t1;
651 SELECT max('101', a) FROM collate4t1;
682 CREATE TABLE collate4t1(a INTEGER PRIMARY KEY);