Lines Matching refs:x1

24   CREATE TABLE x1(a INTEGER PRIMARY KEY, b DOTS);
25   INSERT INTO x1 VALUES(-1, $dots);
26   INSERT INTO x1 VALUES(-10, $dots);
27   INSERT INTO x1 VALUES(-100, $dots);
28   INSERT INTO x1 VALUES(-1000, $dots);
29   INSERT INTO x1 VALUES(-10000, $dots);
40 sqlite3_blob_open db main x1 b -1 0 B
59   sqlite3_blob_open db main x1 b -100 1 B1
60   sqlite3_blob_open db main x1 b -1000 1 B2
61   sqlite3_blob_open db main x1 b -10000 1 B3
62   sqlite3_blob_open db main x1 b -10000 0 B4      ;# B4 is read-only!
83   sqlite3_blob_open db main x1 b -100 1 B1
102   sqlite3_blob_open db main x1 b -100 1 B
106   execsql { INSERT INTO x1 VALUES(15, val()) }
110   execsql { SELECT * FROM x1 WHERE a = 15 }
115   sqlite3_blob_open db main x1 b -100 1 B
119   execsql { SELECT a, val() FROM x1 LIMIT 1 }
124   sqlite3_blob_open db main x1 b -10 1 B
126     INSERT INTO x1 VALUES(1, 'abc');
127     SELECT * FROM x1 WHERE a=1;
132   execsql { SELECT * FROM x1 WHERE a=-10 }
137   execsql { BEGIN ; SELECT * FROM x1 } db2
166   SELECT * FROM x1 WHERE a IN (1, -10);