13
13
# This file implements tests for miscellanous features that were
14
14
# left out of other test files.
16
# $Id: misc2.test,v 1.26 2006/09/29 14:01:07 drh Exp $
16
# $Id: misc2.test,v 1.27 2007/04/06 01:03:34 drh Exp $
18
18
set testdir [file dirname $argv0]
19
19
source $testdir/tester.tcl
253
253
execsql {SELECT * FROM t1}
254
254
} {1 2 3 4 5 6 7 8 9 10}
256
# Repeat the tests 7.1 through 7.8 about but this time do the SELECTs
257
# in reverse order so that we exercise the sqlite3BtreePrev() routine
258
# instead of sqlite3BtreeNext()
262
file delete -force test.db
266
INSERT INTO t1 VALUES(1);
267
INSERT INTO t1 VALUES(2);
268
INSERT INTO t1 VALUES(3);
274
db eval {SELECT rowid FROM t1 ORDER BY rowid DESC} {} {
275
db eval "DELETE FROM t1 WHERE rowid=$rowid"
281
execsql {SELECT * FROM t1}
286
INSERT INTO t1 VALUES(1);
287
INSERT INTO t1 VALUES(2);
288
INSERT INTO t1 VALUES(3);
289
INSERT INTO t1 VALUES(4);
291
db eval {SELECT rowid, x FROM t1 ORDER BY rowid DESC} {
293
db eval {DELETE FROM t1 WHERE rowid=$rowid}
296
execsql {SELECT * FROM t1}
301
INSERT INTO t1 VALUES(1);
302
INSERT INTO t1 VALUES(2);
303
INSERT INTO t1 VALUES(3);
304
INSERT INTO t1 VALUES(4);
306
db eval {SELECT rowid, x FROM t1} {
308
db eval {DELETE FROM t1 WHERE rowid=$rowid+1}
311
execsql {SELECT * FROM t1}
316
INSERT INTO t1 VALUES(1);
317
INSERT INTO t1 VALUES(2);
318
INSERT INTO t1 VALUES(3);
319
INSERT INTO t1 VALUES(4);
321
db eval {SELECT rowid, x FROM t1 ORDER BY rowid DESC} {
323
db eval {DELETE FROM t1}
326
execsql {SELECT * FROM t1}
331
INSERT INTO t1 VALUES(1);
332
INSERT INTO t1 VALUES(2);
333
INSERT INTO t1 VALUES(3);
334
INSERT INTO t1 VALUES(4);
336
db eval {SELECT rowid, x FROM t1 ORDER BY rowid DESC} {
338
db eval {UPDATE t1 SET x=x+100 WHERE rowid=$rowid}
341
execsql {SELECT * FROM t1}
346
INSERT INTO t1(rowid,x) VALUES(10,10);
348
db eval {SELECT rowid, x FROM t1 ORDER BY rowid DESC} {
350
db eval {INSERT INTO t1(rowid,x) VALUES($x-1,$x-1)}
353
execsql {SELECT * FROM t1}
354
} {1 2 3 4 5 6 7 8 9 10}
257
357
file delete -force test.db
258
358
sqlite3 db test.db