Lines Matching refs:c1

66     CREATE TABLE collate1t1(c1, c2);
115     CREATE TABLE collate1t1(c1, c2);
126     SELECT c1, c2 FROM collate1t1 ORDER BY 1 COLLATE numeric, 2 COLLATE hex;
131     SELECT c1, c2 FROM collate1t1 ORDER BY 1 COLLATE binary, 2 COLLATE hex;
136     SELECT c1, c2 FROM collate1t1 ORDER BY 1 COLLATE binary DESC, 2 COLLATE hex;
141     SELECT c1, c2 FROM collate1t1 
147     SELECT c1, c2 FROM collate1t1 
153     SELECT c1 COLLATE numeric, c2 FROM collate1t1 
159     SELECT c1 COLLATE hex, c2 FROM collate1t1 
165     SELECT c1, c2 COLLATE hex FROM collate1t1 
171     SELECT c1 COLLATE numeric, c2 COLLATE hex
178     SELECT c1 COLLATE binary, c2 COLLATE hex
185     SELECT c1, c2
191     SELECT c1 COLLATE binary, c2 COLLATE hex
198     SELECT c1 COLLATE hex, c2 COLLATE binary
242     SELECT a as c1, b as c2 FROM collate1t1 ORDER BY c1;
247     SELECT a as c1, b as c2 FROM collate1t1 ORDER BY c1 COLLATE binary;
252     SELECT a COLLATE binary as c1, b as c2
253       FROM collate1t1 ORDER BY c1;
269     CREATE TABLE collate1t1(c1 numeric, c2 text);
278     SELECT c1 FROM collate1t1 ORDER BY 1;
293     SELECT c1||'' FROM collate1t1 ORDER BY 1;
298     SELECT (c1||'') COLLATE numeric FROM collate1t1 ORDER BY 1;
364   CREATE TABLE c1(x, y REFERENCES p1);
369   INSERT INTO c1 VALUES(1, 'ABC'); 
383   INSERT INTO c1 VALUES(2, 'abb');
384   INSERT INTO c1 VALUES(3, 'wxz');
385   INSERT INTO c1 VALUES(4, 'WXY');
386   SELECT x, y FROM c1 ORDER BY y COLLATE """""""";
415   CREATE TABLE t0(c0 COLLATE RTRIM, c1 BLOB UNIQUE,
416                   PRIMARY KEY (c0, c1)) WITHOUT ROWID;
418   SELECT * FROM t0 WHERE c1 = 1;