Lines Matching refs:t6
433 CREATE TABLE t6(a,b,c);
434 CREATE INDEX t6i1 ON t6(a,b);
435 INSERT INTO t6 VALUES('','',1);
436 INSERT INTO t6 VALUES('',NULL,2);
437 INSERT INTO t6 VALUES(NULL,'',3);
438 INSERT INTO t6 VALUES('abc',123,4);
439 INSERT INTO t6 VALUES(123,'abc',5);
440 SELECT c FROM t6 ORDER BY a,b;
445 SELECT c FROM t6 WHERE a='';
450 SELECT c FROM t6 WHERE b='';
455 SELECT c FROM t6 WHERE a>'';
460 SELECT c FROM t6 WHERE a>='';
465 SELECT c FROM t6 WHERE a>123;
470 SELECT c FROM t6 WHERE a>=123;
475 SELECT c FROM t6 WHERE a<'abc';
480 SELECT c FROM t6 WHERE a<='abc';
485 SELECT c FROM t6 WHERE a<='';
490 SELECT c FROM t6 WHERE a<'';
523 CREATE INDEX "t6i2" ON t6(c);