Lines Matching refs:t4
352 CREATE TABLE t4(a,b);
353 INSERT INTO t4 VALUES('0.0',1);
354 INSERT INTO t4 VALUES('0.00',2);
355 INSERT INTO t4 VALUES('abc',3);
356 INSERT INTO t4 VALUES('-1.0',4);
357 INSERT INTO t4 VALUES('+1.0',5);
358 INSERT INTO t4 VALUES('0',6);
359 INSERT INTO t4 VALUES('00000',7);
360 SELECT a FROM t4 ORDER BY b;
365 SELECT a FROM t4 WHERE a==0 ORDER BY b
370 SELECT a FROM t4 WHERE a<0.5 ORDER BY b
375 SELECT a FROM t4 WHERE a>-0.5 ORDER BY b
380 CREATE INDEX t4i1 ON t4(a);
381 SELECT a FROM t4 WHERE a==0 ORDER BY b
386 SELECT a FROM t4 WHERE a<0.5 ORDER BY b
391 SELECT a FROM t4 WHERE a>-0.5 ORDER BY b