Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add an extra integrity_check to the transaction test script. (CVS 4158) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
5ea43b2db1f0263c5f0ab76351bc9ca9 |
| User & Date: | drh 2007-07-13 10:36:48 |
Context
|
2007-07-17
| ||
| 17:22 | Fix annoying emacs warning about suspicious line. The change removes a leading space (emacs wants Makefiles to use leading tabs there). (CVS 4159) check-in: 4daadf65 user: shess tags: trunk | |
|
2007-07-13
| ||
| 10:36 | Add an extra integrity_check to the transaction test script. (CVS 4158) check-in: 5ea43b2d user: drh tags: trunk | |
| 10:35 | Update documentation to make it clear that VACUUM is free to change implicit rowids. Ticket #2382. (CVS 4157) check-in: d111b1da user: drh tags: trunk | |
Changes
Changes to test/trans.test.
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
..
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
# May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. The # focus of this script is database locks. # # $Id: trans.test,v 1.35 2007/06/18 12:22:43 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Create several tables to work with. ................................................................................ CREATE TABLE one(a int PRIMARY KEY, b text); INSERT INTO one VALUES(1,'one'); INSERT INTO one VALUES(2,'two'); INSERT INTO one VALUES(3,'three'); SELECT b FROM one ORDER BY a; } } {one two three} do_test trans-1.1 { execsql { CREATE TABLE two(a int PRIMARY KEY, b text); INSERT INTO two VALUES(1,'I'); INSERT INTO two VALUES(5,'V'); INSERT INTO two VALUES(10,'X'); SELECT b FROM two ORDER BY a; |
|
>
|
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
..
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
# May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. The # focus of this script is database locks. # # $Id: trans.test,v 1.36 2007/07/13 10:36:48 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Create several tables to work with. ................................................................................ CREATE TABLE one(a int PRIMARY KEY, b text); INSERT INTO one VALUES(1,'one'); INSERT INTO one VALUES(2,'two'); INSERT INTO one VALUES(3,'three'); SELECT b FROM one ORDER BY a; } } {one two three} integrity_check trans-1.0.1 do_test trans-1.1 { execsql { CREATE TABLE two(a int PRIMARY KEY, b text); INSERT INTO two VALUES(1,'I'); INSERT INTO two VALUES(5,'V'); INSERT INTO two VALUES(10,'X'); SELECT b FROM two ORDER BY a; |