Lines Matching refs:t6
435 CREATE TABLE t6(a,b,c);
436 CREATE INDEX t6i1 ON t6(a,b);
437 INSERT INTO t6 VALUES('','',1);
438 INSERT INTO t6 VALUES('',NULL,2);
439 INSERT INTO t6 VALUES(NULL,'',3);
440 INSERT INTO t6 VALUES('abc',123,4);
441 INSERT INTO t6 VALUES(123,'abc',5);
442 SELECT c FROM t6 ORDER BY a,b;
447 SELECT c FROM t6 WHERE a='';
452 SELECT c FROM t6 WHERE b='';
457 SELECT c FROM t6 WHERE a>'';
462 SELECT c FROM t6 WHERE a>='';
467 SELECT c FROM t6 WHERE a>123;
472 SELECT c FROM t6 WHERE a>=123;
477 SELECT c FROM t6 WHERE a<'abc';
482 SELECT c FROM t6 WHERE a<='abc';
487 SELECT c FROM t6 WHERE a<='';
492 SELECT c FROM t6 WHERE a<'';
525 CREATE INDEX "t6i2" ON t6(c);