Lines Matching refs:t2
83 CREATE TABLE t2(a);
84 INSERT INTO t2 VALUES('abc');
85 INSERT INTO t2 VALUES('ABC');
86 SELECT a AS x FROM t2 WHERE x='abc';
91 SELECT a AS x FROM t2 WHERE x='abc' COLLATE nocase;
96 SELECT a AS x FROM t2 WHERE (x COLLATE nocase)='abc';
101 SELECT a COLLATE nocase AS x FROM t2 WHERE x='abc';
106 SELECT a COLLATE nocase AS x FROM t2 WHERE (x COLLATE binary)='abc';
111 SELECT a COLLATE nocase AS x FROM t2 WHERE x='abc' COLLATE binary;
116 SELECT * FROM t2 WHERE (a COLLATE nocase)='abc' COLLATE binary;
121 SELECT a COLLATE nocase AS x FROM t2 WHERE 'abc'=x COLLATE binary;