Lines Matching refs:x
26 CREATE TABLE t1(x TEXT);
55 SELECT x FROM t1 WHERE x LIKE 'abc' ORDER BY 1;
60 SELECT x FROM t1 WHERE x GLOB 'abc' ORDER BY 1;
65 SELECT x FROM t1 WHERE x LIKE 'ABC' ORDER BY 1;
70 SELECT x FROM t1 WHERE x LIKE 'aBc' ORDER BY 1;
79 SELECT x FROM t1 WHERE x LIKE 'abc' ORDER BY 1;
85 SELECT x FROM t1 WHERE x LIKE 'abc' ORDER BY 1;
90 SELECT x FROM t1 WHERE x GLOB 'abc' ORDER BY 1;
95 SELECT x FROM t1 WHERE x LIKE 'ABC' ORDER BY 1;
100 SELECT x FROM t1 WHERE x LIKE 'aBc' ORDER BY 1;
106 SELECT x FROM t1 WHERE x LIKE 'abc' ORDER BY 1;
112 SELECT x FROM t1 WHERE x LIKE 'abc' ORDER BY 1;
124 SELECT x FROM t1 WHERE x REGEXP 'abc' ORDER BY 1;
129 SELECT x FROM t1 WHERE x REGEXP '^abc' ORDER BY 1;
141 SELECT x FROM t1 WHERE x MATCH '*abc*' ORDER BY 1;
146 SELECT x FROM t1 WHERE x MATCH 'abc*' ORDER BY 1;
166 if {$::sqlite_sort_count} {set x sort} {set x nosort}
167 lappend data $x
170 foreach {a b c x} $eqp {
172 $x all ss as tab idx]} {
175 $x all ss as tab idx]} {
177 } elseif {[regexp {(SCAN|SEARCH) (\w+ AS )?(\w+)\y} $x all ss as tab]} {
186 # With no index on t1.x and with case sensitivity turned off, no optimization
192 SELECT x FROM t1 WHERE x LIKE 'abc%' ORDER BY 1;
199 # With an index on t1.x and case sensitivity on, optimize completely.
205 CREATE INDEX i1 ON t1(x);
208 SELECT x FROM t1 WHERE x LIKE 'abc%' ORDER BY 1;
227 SELECT x FROM t1 WHERE x LIKE $::likepat ORDER BY 1;
242 SELECT x FROM t1 WHERE x LIKE $::likepat ORDER BY 1;
254 SELECT x FROM t1 WHERE x LIKE 'abc%' ORDER BY 1;
267 SELECT x FROM t1 WHERE x LIKE 'a' ORDER BY 1;
272 SELECT x FROM t1 WHERE x LIKE 'ab' ORDER BY 1;
277 SELECT x FROM t1 WHERE x LIKE 'abcd' ORDER BY 1;
282 SELECT x FROM t1 WHERE x LIKE 'abcde' ORDER BY 1;
292 SELECT x FROM t1 WHERE x LIKE 'a_c' ORDER BY 1;
301 SELECT x FROM t1 WHERE x LIKE 'ab%d' ORDER BY 1;
310 SELECT x FROM t1 WHERE x LIKE 'a_c%' ORDER BY 1;
323 SELECT x FROM t1 WHERE x LIKE '%bcd' ORDER BY 1;
336 SELECT x FROM t1 WHERE x LIKE 'abc%' ORDER BY 1;
352 SELECT x FROM t1 WHERE x LIKE 'abc%' ORDER BY 1;
364 SELECT x FROM t1 WHERE x GLOB 'abc*' ORDER BY 1;
375 db eval {CREATE INDEX i1 ON t1(x);}
377 SELECT x FROM t1 WHERE x GLOB 'abc*' ORDER BY 1;
387 SELECT x FROM t1 WHERE x GLOB 'abc*' ORDER BY 1;
397 SELECT x FROM t1 WHERE x GLOB 'a[bc]d' ORDER BY 1;
408 SELECT x FROM t1 WHERE x GLOB 'a' ORDER BY 1;
413 SELECT x FROM t1 WHERE x GLOB 'abcd' ORDER BY 1;
418 SELECT x FROM t1 WHERE x GLOB 'abcde' ORDER BY 1;
431 SELECT x FROM t1 WHERE x LIKE 'abc%' ORDER BY 1
440 SELECT x FROM t1 WHERE +x LIKE 'abc%' ORDER BY 1
449 SELECT x FROM t1 WHERE x LIKE ('ab' || 'c%') ORDER BY 1
464 SELECT x FROM t1 WHERE x LIKE 'abc%' ORDER BY 1
472 CREATE TABLE t2(x TEXT COLLATE NOCASE);
474 CREATE INDEX i2 ON t2(x COLLATE NOCASE);
478 SELECT x FROM t2 WHERE x LIKE 'abc%' ORDER BY 1
490 SELECT x FROM t2 WHERE x LIKE 'abc%' ORDER BY 1
502 SELECT x FROM t2 WHERE x GLOB 'abc*' ORDER BY 1
512 SELECT x FROM t1 WHERE x LIKE 'ABC%' ORDER BY 1
521 SELECT x FROM t2 WHERE x LIKE 'ABC%' ORDER BY 1
533 SELECT x FROM t2 WHERE x LIKE 'ABC%' ORDER BY 1
545 SELECT x FROM t2 WHERE x GLOB 'ABC*' ORDER BY 1
570 SELECT x FROM t2 WHERE x LIKE 'zz%';
575 SELECT x FROM t2 WHERE x LIKE 'zZ%';
580 SELECT x FROM t2 WHERE x LIKE 'Zz%';
585 SELECT x FROM t2 WHERE x LIKE 'ZZ%';
591 CREATE TABLE t3(x TEXT);
592 CREATE INDEX i3 ON t3(x);
599 SELECT x FROM t3 WHERE x LIKE 'zz%';
604 SELECT x FROM t3 WHERE x LIKE 'zZ%';
609 SELECT x FROM t3 WHERE x LIKE 'Zz%';
614 SELECT x FROM t3 WHERE x LIKE 'ZZ%';
625 foreach x { 'abc 'bcd 'def 'ax } {
626 set x2 '[string map {' ''} $x]'
630 SELECT * FROM t2 WHERE x LIKE '''a%'
647 CREATE TABLE t8(x);
651 SELECT 1, x FROM t8 WHERE x LIKE '%h%';
652 SELECT 2, x FROM t8 WHERE x LIKE '%h%' ESCAPE 'x';
660 SELECT 1, x FROM t8 WHERE x LIKE '%h%';
661 SELECT 2, x FROM t8 WHERE x LIKE '%h%' ESCAPE 'x';
667 SELECT 1, x FROM t8 WHERE x LIKE '%h%';
668 SELECT 2, x FROM t8 WHERE x LIKE '%h%' ESCAPE 'x';
674 SELECT 1, x FROM t8 WHERE x LIKE '%h%';
675 SELECT 2, x FROM t8 WHERE x LIKE '%h%' ESCAPE 'x';
692 SELECT x FROM t2 WHERE x LIKE 'x%'
697 SELECT x FROM t2 WHERE x LIKE '_y%'
702 SELECT x FROM t2 WHERE x LIKE '%78%25'
704 } {0 {x xyz}}
708 EXPLAIN QUERY PLAN SELECT x FROM t2 WHERE x LIKE '%78%25'
716 SELECT substr(x,2) AS x FROM t2 WHERE +x LIKE '%ff%25'
718 } {0 {x hello}}
721 SELECT substr(x,2) AS x FROM t2 WHERE x LIKE '%ff%25'
723 } {0 {x hello}}
727 EXPLAIN QUERY PLAN SELECT x FROM t2 WHERE x LIKE '%ff%25'
734 SELECT x FROM t2 WHERE x LIKE '%fe%25'
740 EXPLAIN QUERY PLAN SELECT x FROM t2 WHERE x LIKE '%fe%25'
884 INSERT INTO t11 VALUES(9, 'x','x');
965 CREATE TABLE t12nc(id INTEGER, x TEXT UNIQUE COLLATE nocase);
967 CREATE TABLE t12b(id INTEGER, x TEXT UNIQUE COLLATE binary);
969 SELECT id FROM t12nc WHERE x LIKE 'abc%' ORDER BY +id;
972 SELECT id FROM t12b WHERE x LIKE 'abc%' ORDER BY +id;
975 SELECT id FROM t12nc WHERE x LIKE 'abc%' COLLATE binary ORDER BY +id;
978 SELECT id FROM t12b WHERE x LIKE 'abc%' COLLATE binary ORDER BY +id;
981 SELECT id FROM t12nc WHERE x LIKE 'abc%' COLLATE nocase ORDER BY +id;
984 SELECT id FROM t12b WHERE x LIKE 'abc%' COLLATE nocase ORDER BY +id;
993 SELECT id FROM t12nc WHERE x LIKE 'abc%' ORDER BY +id;
997 SELECT id FROM t12b WHERE x LIKE 'abc%' ORDER BY +id;
1001 SELECT id FROM t12nc WHERE x LIKE 'abc%' COLLATE nocase ORDER BY +id;
1005 SELECT id FROM t12b WHERE x LIKE 'abc%' COLLATE nocase ORDER BY +id;
1009 SELECT id FROM t12nc WHERE x LIKE 'abc%' COLLATE binary ORDER BY +id;
1013 SELECT id FROM t12b WHERE x LIKE 'abc%' COLLATE binary ORDER BY +id;
1036 set x [lindex [time {
1040 puts -nonewline " ($x ms - want less than $tlimit) "
1041 expr {$x<$tlimit}
1045 set x [lindex [time {
1049 puts -nonewline " ($x ms - want less than $tlimit) "
1050 expr {$x<$tlimit}
1061 CREATE TABLE t15(x TEXT COLLATE nocase, y, PRIMARY KEY(x));
1062 INSERT INTO t15(x,y) VALUES
1068 SELECT y FROM t15 WHERE x LIKE 'ab/%d%' ESCAPE '/';
1072 SELECT y FROM t15 WHERE x LIKE 'ab/%d%' ESCAPE '/';
1076 SELECT y FROM t15 WHERE x LIKE 'ab/%d%' ESCAPE '//';
1080 SELECT y FROM t15 WHERE x LIKE 'ab/%d%' ESCAPE '';
1083 SELECT y FROM t15 WHERE x LIKE 'abcdx%%' ESCAPE 'x';
1086 SELECT y FROM t15 WHERE x LIKE 'abx%%' ESCAPE 'x' ORDER BY +y
1090 SELECT y FROM t15 WHERE x LIKE 'abx%%' ESCAPE 'x' ORDER BY +y
1093 SELECT y FROM t15 WHERE x LIKE '/%bc%' ESCAPE '/';
1097 SELECT y FROM t15 WHERE x LIKE '/%bc%' ESCAPE '/';
1108 INSERT INTO t1 VALUES(' 1x');
1113 } {{ 1x} { 1-}}
1123 CREATE TABLE t1(id INTEGER PRIMARY KEY, x TEXT);
1130 SELECT id FROM t1 WHERE x LIKE 'abc%%' ESCAPE '%';
1133 SELECT id FROM t1 WHERE x LIKE 'abc__' ESCAPE '_';
1139 SELECT 'x' LIKE '%' ESCAPE '_';