Lines Matching refs:test1

22   execsql {CREATE TABLE test1(i1 int, i2 int, r1 real, r2 real, t1 text, t2 text)}
23   execsql {INSERT INTO test1 VALUES(1,2,1.1,2.2,'hello','world')}
26   execsql {CREATE TABLE test1(i1 int, i2 int, t1 text, t2 text)}
27   execsql {INSERT INTO test1 VALUES(1,2,'hello','world')}
32     execsql {BEGIN; UPDATE test1 SET %s; SELECT %s FROM test1; ROLLBACK;}
37     execsql {BEGIN; UPDATE test1 SET %s; SELECT %s FROM test1; ROLLBACK;}
740 execsql {DROP TABLE test1}
741 execsql {CREATE TABLE test1(a int, b int);}
743   execsql "INSERT INTO test1 VALUES($i,[expr {1<<$i}])"
745 execsql "INSERT INTO test1 VALUES(NULL,0)"
747   execsql {SELECT * FROM test1 ORDER BY a}
752     execsql {SELECT a FROM test1 WHERE %s ORDER BY a}
936     SELECT (CASE a>4 THEN 1 ELSE 0 END) FROM test1;
941     SELECT (CASE WHEN a>4 THEN 1 ELSE 0) FROM test1;