Lines Matching refs:x

21 #     CREATE TABLE t1(x TEXT UNIQUE COLLATE nocase);
22 #     INSERT INTO t1(x) VALUES(x'616263');
23 #     SELECT 'query-1', x FROM t1 WHERE x LIKE 'a%';
24 #     SELECT 'query-2', x FROM t1 WHERE +x LIKE 'a%';
44            (4,x'616263'),
45            (5,x'414258'),
46            (6,x'424344');
65   SELECT a, b FROM t2 WHERE b>=x'6162' AND b GLOB 'ab*'
68   SELECT a, b FROM t2 WHERE +b>=x'6162' AND +b GLOB 'ab*'
71   SELECT a, b FROM t2 WHERE b GLOB 'ab*' AND b>=x'6162'
74   SELECT a, b FROM t2 WHERE +b GLOB 'ab*' AND +b>=x'6162'
78   CREATE TABLE t3(x TEXT PRIMARY KEY COLLATE nocase);
79   INSERT INTO t3(x) VALUES('aaa'),('abc'),('abd'),('abe'),('acz');
80   INSERT INTO t3(x) SELECT CAST(x AS blob) FROM t3;
81   SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY x;
84   SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY x DESC;
87   SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY +x DESC;
90   SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY x ASC;
93   SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY +x ASC;
97   CREATE TABLE t4(x TEXT COLLATE nocase);
98   CREATE INDEX t4x ON t4(x DESC);
99   INSERT INTO t4(x) SELECT x FROM t3;
100   SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY x;
103   SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY x DESC;
106   SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY +x DESC;
109   SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY x ASC;
112   SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY +x ASC;
120   CREATE TABLE t5a(x INT UNIQUE COLLATE nocase);
121   INSERT INTO t5a(x) VALUES('/abc'),(123),(-234);
122   SELECT x FROM t5a WHERE x LIKE '/%';
125   SELECT x FROM t5a WHERE x LIKE '/%';
131   SELECT x FROM t5a WHERE x LIKE '/a%';
135   SELECT x FROM t5a WHERE x LIKE '/a%';
138   `--SEARCH t5a USING COVERING INDEX sqlite_autoindex_t5a_1 (x>? AND x<?)
142   SELECT x FROM t5a WHERE x LIKE '^12%' ESCAPE '^';
145   SELECT x FROM t5a WHERE x LIKE '^12%' ESCAPE '^';
151   SELECT x FROM t5a WHERE x LIKE '^-2%' ESCAPE '^';
154   SELECT x FROM t5a WHERE x LIKE '^12%' ESCAPE '^';
161   CREATE TABLE t5b(x INT UNIQUE COLLATE binary);
162   INSERT INTO t5b(x) VALUES('/abc'),(123),(-234);
163   SELECT x FROM t5b WHERE x GLOB '/*';
166   SELECT x FROM t5b WHERE x GLOB '/*';
172   SELECT x FROM t5b WHERE x GLOB '/a*';
175   SELECT x FROM t5b WHERE x GLOB '/a*';
178   `--SEARCH t5b USING COVERING INDEX sqlite_autoindex_t5b_1 (x>? AND x<?)
240   SELECT * FROM t1 WHERE path LIKE 'a%' ESCAPE 'x';
247   CREATE TABLE t2(path TEXT,x,y,z);