Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Improve the new test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | tkt-1f7bfff467 |
| Files: | files | file ages | folders |
| SHA1: | 588b7768a08f9b5fd63f56c2b234442d |
| User & Date: | mistachkin 2016-10-28 21:30:08 |
Context
|
2016-10-29
| ||
| 22:19 | Make the SAVEPOINT names used for nested transactions much less predictable. check-in: 09db2a0a1b user: mistachkin tags: tkt-1f7bfff467 | |
|
2016-10-28
| ||
| 21:30 | Improve the new test. check-in: 588b7768a0 user: mistachkin tags: tkt-1f7bfff467 | |
| 21:19 | Minor correction to the previous check-in. check-in: 597c25de3b user: mistachkin tags: tkt-1f7bfff467 | |
Changes
Changes to Tests/tkt-1f7bfff467.eagle.
28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
INSERT INTO t1(x) VALUES(1);
INSERT INTO t1(x) VALUES(2);
INSERT INTO t1(x) VALUES(3);
}
set result [list]
set transaction(1) [sql transaction begin $db]
lappend result [sql execute -transaction $transaction(1) \
-execute scalar $db "SELECT COUNT(*) FROM t1;"]
sql execute -transaction $transaction(1) $db \
"INSERT INTO t1(x) VALUES(4);"
lappend result [sql execute -transaction $transaction(1) \
-execute reader -format list $db \
"SELECT x FROM t1 ORDER BY x;"]
|
| | | | |
28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
INSERT INTO t1(x) VALUES(1);
INSERT INTO t1(x) VALUES(2);
INSERT INTO t1(x) VALUES(3);
}
set result [list]
lappend result [sql execute \
-execute scalar $db "SELECT COUNT(*) FROM t1;"]
set transaction(1) [sql transaction begin $db]
sql execute -transaction $transaction(1) $db \
"INSERT INTO t1(x) VALUES(4);"
lappend result [sql execute -transaction $transaction(1) \
-execute reader -format list $db \
"SELECT x FROM t1 ORDER BY x;"]
|