Lines Matching refs:SELECT
82 cksort {SELECT a FROM collate4t1 ORDER BY a}
85 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE NOCASE}
88 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE TEXT}
91 cksort {SELECT b FROM collate4t1 ORDER BY b}
94 cksort {SELECT b FROM collate4t1 ORDER BY b COLLATE TEXT}
97 cksort {SELECT b FROM collate4t1 ORDER BY b COLLATE NOCASE}
112 cksort {SELECT a FROM collate4t2 ORDER BY a}
115 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE NOCASE}
118 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE TEXT}
121 cksort {SELECT b FROM collate4t2 ORDER BY b}
124 cksort {SELECT b FROM collate4t2 ORDER BY b COLLATE TEXT}
127 cksort {SELECT b FROM collate4t2 ORDER BY b COLLATE NOCASE}
143 cksort {SELECT a FROM collate4t3 ORDER BY a}
146 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE NOCASE}
149 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE TEXT}
152 cksort {SELECT b FROM collate4t3 ORDER BY b}
155 cksort {SELECT b FROM collate4t3 ORDER BY b COLLATE TEXT}
158 cksort {SELECT b FROM collate4t3 ORDER BY b COLLATE NOCASE}
174 cksort {SELECT a FROM collate4t4 ORDER BY a}
177 cksort {SELECT a FROM collate4t4 ORDER BY a COLLATE NOCASE}
180 cksort {SELECT a FROM collate4t4 ORDER BY a COLLATE TEXT}
183 cksort {SELECT b FROM collate4t4 ORDER BY b}
186 cksort {SELECT b FROM collate4t4 ORDER BY b COLLATE TEXT}
189 cksort {SELECT b FROM collate4t4 ORDER BY b COLLATE NOCASE}
213 cksort {SELECT a FROM collate4t1 ORDER BY a}
216 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE nocase}
219 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE text}
222 cksort {SELECT a FROM collate4t1 ORDER BY a, b}
225 cksort {SELECT a FROM collate4t1 ORDER BY a, b COLLATE nocase}
228 cksort {SELECT a FROM collate4t1 ORDER BY a, b COLLATE text}
244 cksort {SELECT a FROM collate4t2 ORDER BY a}
247 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE nocase}
250 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE text}
253 cksort {SELECT a FROM collate4t2 ORDER BY a, b}
256 cksort {SELECT a FROM collate4t2 ORDER BY a, b COLLATE nocase}
259 cksort {SELECT a FROM collate4t2 ORDER BY a, b COLLATE text}
274 cksort {SELECT a FROM collate4t3 ORDER BY a}
277 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE nocase}
280 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text}
283 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text, b}
286 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text, b COLLATE nocase}
289 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text, b COLLATE text}
292 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text DESC}
295 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text DESC, b}
298 cksort {SELECT a FROM collate4t3
302 cksort {SELECT a FROM collate4t3
345 SELECT * FROM collate4t2, collate4t1 WHERE a = b;
353 SELECT * FROM collate4t2, collate4t1 WHERE a = b;
358 SELECT * FROM collate4t2, collate4t1 WHERE b = a;
367 SELECT * FROM collate4t2, collate4t1 WHERE a = b;
372 SELECT * FROM collate4t2, collate4t1 WHERE b = a;
378 SELECT a FROM collate4t1 WHERE a IN (SELECT * FROM collate4t2);
387 SELECT a FROM collate4t1 WHERE a IN (SELECT * FROM collate4t2);
392 SELECT a FROM collate4t1 WHERE a IN ('z', 'a');
401 SELECT a FROM collate4t1 WHERE a IN ('z', 'a');
425 insert into collate4t2 SELECT * FROM collate4t1;
430 SELECT * FROM collate4t2 NOT INDEXED NATURAL JOIN collate4t1 NOT INDEXED;
438 SELECT * FROM collate4t2 NATURAL JOIN collate4t1;
447 SELECT * FROM collate4t2 NATURAL JOIN collate4t1;
476 SELECT * FROM collate4t1;
481 INSERT INTO collate4t1 SELECT upper(a) FROM collate4t1;
504 SELECT * FROM collate4t1;
509 INSERT INTO collate4t1 SELECT upper(a) FROM collate4t1;
533 SELECT * FROM collate4t1;
538 INSERT INTO collate4t1 SELECT upper(a) FROM collate4t1;
579 SELECT max(a) FROM collate4t1
584 SELECT min(a) FROM collate4t1
593 SELECT min(a) FROM collate4t1;
598 SELECT max(a) FROM collate4t1;
608 SELECT min(a) FROM collate4t1;
613 SELECT max(a) FROM collate4t1;
633 SELECT max(a, b) FROM collate4t1;
638 SELECT max(b, a) FROM collate4t1;
643 SELECT max(a, '101') FROM collate4t1;
648 SELECT max('101', a) FROM collate4t1;
653 SELECT max(b, '101') FROM collate4t1;
658 SELECT max('101', b) FROM collate4t1;
687 SELECT * FROM collate4t1 ORDER BY 1;
692 SELECT * FROM collate4t1 ORDER BY oid;
697 SELECT * FROM collate4t1 ORDER BY oid||'' COLLATE TEXT;
