Lines Matching refs:main

59   5    "UPDATE main.t1 SET a=10" {}
60   6    "UPDATE main.t1 SET a=10, b=5" {}
61   7    "UPDATE main.t1 SET a=10 WHERE b=5" {}
66   13   "UPDATE OR ROLLBACK main.t1 SET a=10" {}
67   14   "UPDATE OR ROLLBACK main.t1 SET a=10, b=5" {}
68   15   "UPDATE OR ROLLBACK main.t1 SET a=10 WHERE b=5" {}
69   16   "UPDATE OR ROLLBACK main.t1 SET b=5,a=10 WHERE 1" {}
74   21   "UPDATE OR ABORT main.t1 SET a=10" {}
75   22   "UPDATE OR ABORT main.t1 SET a=10, b=5" {}
76   23   "UPDATE OR ABORT main.t1 SET a=10 WHERE b=5" {}
77   24   "UPDATE OR ABORT main.t1 SET b=5,a=10 WHERE 1" {}
82   29   "UPDATE OR REPLACE main.t1 SET a=10" {}
83   30   "UPDATE OR REPLACE main.t1 SET a=10, b=5" {}
84   31   "UPDATE OR REPLACE main.t1 SET a=10 WHERE b=5" {}
85   32   "UPDATE OR REPLACE main.t1 SET b=5,a=10 WHERE 1" {}
90   37   "UPDATE OR FAIL main.t1 SET a=10" {}
91   38   "UPDATE OR FAIL main.t1 SET a=10, b=5" {}
92   39   "UPDATE OR FAIL main.t1 SET a=10 WHERE b=5" {}
93   40   "UPDATE OR FAIL main.t1 SET b=5,a=10 WHERE 1" {}
98   45   "UPDATE OR IGNORE main.t1 SET a=10" {}
99   46   "UPDATE OR IGNORE main.t1 SET a=10, b=5" {}
100   47   "UPDATE OR IGNORE main.t1 SET a=10 WHERE b=5" {}
101   48   "UPDATE OR IGNORE main.t1 SET b=5,a=10 WHERE 1" {}
115   INSERT INTO main.t1 VALUES(1, 'i');
116   INSERT INTO main.t1 VALUES(2, 'ii');
117   INSERT INTO main.t1 VALUES(3, 'iii');
125   1.2  "UPDATE main.t1 SET a = a+1; SELECT * FROM main.t1"   {3 i  4 ii  5 iii}
136   DELETE FROM main.t1;
137   INSERT INTO main.t1 VALUES(1, 'i');
138   INSERT INTO main.t1 VALUES(2, 'ii');
139   INSERT INTO main.t1 VALUES(3, 'iii');
153   DELETE FROM main.t1;
154   INSERT INTO main.t1 VALUES(NULL, '');
155   INSERT INTO main.t1 VALUES(1, 'i');
156   INSERT INTO main.t1 VALUES(2, 'ii');
157   INSERT INTO main.t1 VALUES(3, 'iii');
178   DELETE FROM main.t1;
179   INSERT INTO main.t1 VALUES(NULL, '');
180   INSERT INTO main.t1 VALUES(1, 'i');
181   INSERT INTO main.t1 VALUES(2, 'ii');
182   INSERT INTO main.t1 VALUES(3, 'iii');
333         UPDATE main.t2 SET a=1, b=2, c=3;
345         UPDATE main.t1 SET a=1, b=2;
362   } "main.t4"
380 # main database, then any other databases in the order they were
384   SELECT 'main', tbl_name FROM main.sqlite_master WHERE type = 'table';
388     main t1
389     main t2
390     main t3
391     main t6
398   DELETE FROM main.t6;
400   INSERT INTO main.t6 VALUES(1, 2);
408   SELECT * FROM main.t6;
412   DELETE FROM main.t1;
414   INSERT INTO main.t1 VALUES(1, 2);
422   SELECT * FROM main.t1;