Lines Matching refs:t5

482     CREATE TABLE t5(a);
483     INSERT INTO t5 VALUES(1);
484     INSERT INTO t5 VALUES(2);
485     INSERT INTO t5 SELECT a+2 FROM t5;
486     INSERT INTO t5 SELECT a+4 FROM t5;
487     SELECT rowid, * FROM t5;
491   execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.5}
494   execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.0}
497   execsql {SELECT rowid, a FROM t5 WHERE rowid>5.5}
500   execsql {SELECT rowid, a FROM t5 WHERE rowid>5.0}
503   execsql {SELECT rowid, a FROM t5 WHERE 5.5<=rowid}
506   execsql {SELECT rowid, a FROM t5 WHERE 5.5<rowid}
509   execsql {SELECT rowid, a FROM t5 WHERE rowid<=5.5}
512   execsql {SELECT rowid, a FROM t5 WHERE rowid<5.5}
515   execsql {SELECT rowid, a FROM t5 WHERE 5.5>=rowid}
518   execsql {SELECT rowid, a FROM t5 WHERE 5.5>rowid}
521   execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.5 ORDER BY rowid DESC}
524   execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.0 ORDER BY rowid DESC}
527   execsql {SELECT rowid, a FROM t5 WHERE rowid>5.5 ORDER BY rowid DESC}
530   execsql {SELECT rowid, a FROM t5 WHERE rowid>5.0 ORDER BY rowid DESC}
533   execsql {SELECT rowid, a FROM t5 WHERE 5.5<=rowid ORDER BY rowid DESC}
536   execsql {SELECT rowid, a FROM t5 WHERE 5.5<rowid ORDER BY rowid DESC}
539   execsql {SELECT rowid, a FROM t5 WHERE rowid<=5.5 ORDER BY rowid DESC}
542   execsql {SELECT rowid, a FROM t5 WHERE rowid<5.5 ORDER BY rowid DESC}
545   execsql {SELECT rowid, a FROM t5 WHERE 5.5>=rowid ORDER BY rowid DESC}
548   execsql {SELECT rowid, a FROM t5 WHERE 5.5>rowid ORDER BY rowid DESC}
554     INSERT INTO t6(rowid,a) SELECT -a,a FROM t5;
622   execsql {SELECT rowid, a FROM t5 WHERE rowid>'abc'}
625   execsql {SELECT rowid, a FROM t5 WHERE rowid>='abc'}
628   execsql {SELECT rowid, a FROM t5 WHERE rowid<'abc'}
631   execsql {SELECT rowid, a FROM t5 WHERE rowid<='abc'}