/ Check-in [8289c3e9]
Login

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:8289c3e9b47f7c2a606a88839f6bf615f8904ac2
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/misc8.test.

    32     32     SELECT eval('SELECT * FROM t1 ORDER BY a',',');
    33     33   } {1,2,3,4,5,6,7,,9}
    34     34   do_catchsql_test misc8-1.4 {
    35     35     BEGIN;
    36     36     INSERT INTO t1 VALUES(10,11,12);
    37     37     SELECT coalesce(b, eval('ROLLBACK')) FROM t1 ORDER BY a;
    38     38   } {1 {abort due to ROLLBACK}}
           39  +do_catchsql_test misc8-1.5 {
           40  +  INSERT INTO t1 VALUES(10,11,12);
           41  +  SELECT a, coalesce(b, eval('SELECT ''bam''')), c
           42  +    FROM t1
           43  +   ORDER BY rowid;
           44  +} {0 {1 2 3 4 5 6 7 bam 9 10 11 12}}
           45  +do_catchsql_test misc8-1.6 {
           46  +  SELECT a, coalesce(b, eval('DELETE FROM t1; SELECT ''bam''')), c
           47  +    FROM t1
           48  +   ORDER BY rowid;
           49  +} {0 {1 2 3 4 5 6 7 bam {}}}
    39     50   
    40     51   
    41     52   finish_test