Lines Matching refs:c1

35     CREATE TABLE collate3t1(c1 UNIQUE);
45     SELECT DISTINCT c1 COLLATE garbage FROM collate3t1;
50     CREATE TABLE collate3t2(c1 collate garbage);
55     CREATE INDEX collate3i1 ON collate3t1(c1 COLLATE garbage);
179     CREATE TABLE collate3t1(c1 COLLATE string_compare, c2);
192     SELECT * FROM collate3t1 ORDER BY c1;
197     SELECT * FROM collate3t1 WHERE c1 = 'xxx';
202     CREATE TABLE collate3t2(c1 COLLATE string_compare);
207     CREATE INDEX collate3t1_i1 ON collate3t1(c1);
217     SELECT count(*) FROM collate3t1 GROUP BY c1;
222 #     SELECT * FROM collate3t1 GROUP BY c1;
227     SELECT * FROM collate3t1 GROUP BY c1;
232     SELECT DISTINCT c1 FROM collate3t1;
239       SELECT c1 FROM collate3t1 UNION SELECT c1 FROM collate3t1;
244       SELECT c1 FROM collate3t1 EXCEPT SELECT c1 FROM collate3t1;
249       SELECT c1 FROM collate3t1 INTERSECT SELECT c1 FROM collate3t1;
254       SELECT c1 FROM collate3t1 UNION ALL SELECT c1 FROM collate3t1;
279       SELECT c1 FROM collate3t1 UNION ALL SELECT c1 FROM collate3t1 ORDER BY 1;
300     CREATE INDEX collate3t1_i1 ON collate3t1(c1);
315     UPDATE collate3t1 SET c1 = 'xxx';
357     SELECT * FROM collate3t1 ORDER BY c1;
362     SELECT * FROM collate3t1 WHERE c1 = 'xxx';
367     CREATE TABLE collate3t2(c1 COLLATE string_compare);
372     CREATE INDEX collate3t1_i2 ON collate3t1(c1);