Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | New test cases for deleting content out from under a SELECT statement. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
8289c3e9b47f7c2a606a88839f6bf615 |
| User & Date: | drh 2014-11-10 19:16:59 |
Context
|
2014-11-11
| ||
| 12:20 | Add new test file e_blobclose.test, containing tests for sqlite3_blob_close(). (check-in: 5a1eac24 user: dan tags: trunk) | |
| 01:33 | Experimental changes that permit read operations to continue after a ROLLBACK, as long as the schema is unchanged. (Closed-Leaf check-in: fa6e6a9a user: drh tags: read-after-rollback) | |
|
2014-11-10
| ||
| 19:16 | New test cases for deleting content out from under a SELECT statement. (check-in: 8289c3e9 user: drh tags: trunk) | |
| 17:53 | Add test file e_blobwrite.test, containing tests for the sqlite3_blob_write() interface. (check-in: 1df77e5f user: dan tags: trunk) | |
Changes
Changes to test/misc8.test.
32 33 34 35 36 37 38 39 40 41 |
SELECT eval('SELECT * FROM t1 ORDER BY a',',');
} {1,2,3,4,5,6,7,,9}
do_catchsql_test misc8-1.4 {
BEGIN;
INSERT INTO t1 VALUES(10,11,12);
SELECT coalesce(b, eval('ROLLBACK')) FROM t1 ORDER BY a;
} {1 {abort due to ROLLBACK}}
finish_test
|
> > > > > > > > > > > |
32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 |
SELECT eval('SELECT * FROM t1 ORDER BY a',',');
} {1,2,3,4,5,6,7,,9}
do_catchsql_test misc8-1.4 {
BEGIN;
INSERT INTO t1 VALUES(10,11,12);
SELECT coalesce(b, eval('ROLLBACK')) FROM t1 ORDER BY a;
} {1 {abort due to ROLLBACK}}
do_catchsql_test misc8-1.5 {
INSERT INTO t1 VALUES(10,11,12);
SELECT a, coalesce(b, eval('SELECT ''bam''')), c
FROM t1
ORDER BY rowid;
} {0 {1 2 3 4 5 6 7 bam 9 10 11 12}}
do_catchsql_test misc8-1.6 {
SELECT a, coalesce(b, eval('DELETE FROM t1; SELECT ''bam''')), c
FROM t1
ORDER BY rowid;
} {0 {1 2 3 4 5 6 7 bam {}}}
finish_test
|