Lines Matching refs:t5

480     CREATE TABLE t5(a);
481     INSERT INTO t5 VALUES(1);
482     INSERT INTO t5 VALUES(2);
483     INSERT INTO t5 SELECT a+2 FROM t5;
484     INSERT INTO t5 SELECT a+4 FROM t5;
485     SELECT rowid, * FROM t5;
489   execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.5}
492   execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.0}
495   execsql {SELECT rowid, a FROM t5 WHERE rowid>5.5}
498   execsql {SELECT rowid, a FROM t5 WHERE rowid>5.0}
501   execsql {SELECT rowid, a FROM t5 WHERE 5.5<=rowid}
504   execsql {SELECT rowid, a FROM t5 WHERE 5.5<rowid}
507   execsql {SELECT rowid, a FROM t5 WHERE rowid<=5.5}
510   execsql {SELECT rowid, a FROM t5 WHERE rowid<5.5}
513   execsql {SELECT rowid, a FROM t5 WHERE 5.5>=rowid}
516   execsql {SELECT rowid, a FROM t5 WHERE 5.5>rowid}
519   execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.5 ORDER BY rowid DESC}
522   execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.0 ORDER BY rowid DESC}
525   execsql {SELECT rowid, a FROM t5 WHERE rowid>5.5 ORDER BY rowid DESC}
528   execsql {SELECT rowid, a FROM t5 WHERE rowid>5.0 ORDER BY rowid DESC}
531   execsql {SELECT rowid, a FROM t5 WHERE 5.5<=rowid ORDER BY rowid DESC}
534   execsql {SELECT rowid, a FROM t5 WHERE 5.5<rowid ORDER BY rowid DESC}
537   execsql {SELECT rowid, a FROM t5 WHERE rowid<=5.5 ORDER BY rowid DESC}
540   execsql {SELECT rowid, a FROM t5 WHERE rowid<5.5 ORDER BY rowid DESC}
543   execsql {SELECT rowid, a FROM t5 WHERE 5.5>=rowid ORDER BY rowid DESC}
546   execsql {SELECT rowid, a FROM t5 WHERE 5.5>rowid ORDER BY rowid DESC}
552     INSERT INTO t6(rowid,a) SELECT -a,a FROM t5;
620   execsql {SELECT rowid, a FROM t5 WHERE rowid>'abc'}
623   execsql {SELECT rowid, a FROM t5 WHERE rowid>='abc'}
626   execsql {SELECT rowid, a FROM t5 WHERE rowid<'abc'}
629   execsql {SELECT rowid, a FROM t5 WHERE rowid<='abc'}