Lines Matching refs:r1

213   CREATE TABLE r1(a UNIQUE, b UNIQUE);
214   INSERT INTO r1 VALUES('i', 'i');
215   INSERT INTO r1 VALUES('ii', 'ii');
216   INSERT INTO r1 VALUES('iii', 'iii');
217   INSERT INTO r1 VALUES('iv', 'iv');
218   INSERT INTO r1 VALUES('v', 'v');
219   INSERT INTO r1 VALUES('vi', 'vi');
220   INSERT INTO r1 VALUES('vii', 'vii');
223 do_changes_test 3.3.1 { INSERT OR REPLACE INTO r1 VALUES('i', 1)    }   1
224 do_changes_test 3.3.2 { INSERT OR REPLACE INTO r1 VALUES('iv', 'v') }   1
225 do_changes_test 3.3.3 { UPDATE OR REPLACE r1 SET b='v' WHERE a='iii' }  1
226 do_changes_test 3.3.4 { UPDATE OR REPLACE r1 SET b='vi',a='vii' WHERE a='ii' } 1
228   SELECT * FROM r1 ORDER BY a;