/ Check-in [87dc82d0]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Verify that a RAISE(ROLLBACK,...) works like RAISE(FAIL,...) when not inside a transaction. Ticket #3035. (CVS 4979)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 87dc82d0436c6c3a9bd67544d52911012a5a7c66
User & Date: drh 2008-04-10 15:12:46
Context
2008-04-10
16:01
Give file scope to the sqlite3Apis constant. Ticket #3024. (CVS 4980) check-in: 30c50860 user: drh tags: trunk
15:12
Verify that a RAISE(ROLLBACK,...) works like RAISE(FAIL,...) when not inside a transaction. Ticket #3035. (CVS 4979) check-in: 87dc82d0 user: drh tags: trunk
14:57
Make sure all memory allocations are 8-byte aligned. Ticket #3040. Note that the mem3.c memory allocator returns 4-byte aligned memory allocations. But as mem3.c is intended for use in 32-bit embedded systems, we are not going to change that. (CVS 4978) check-in: d11e8e30 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Show Whitespace Changes Patch

Changes to test/trigger3.test.

    74     74       }
    75     75   } {1 {Trigger rollback}}
    76     76   do_test trigger3-3.2 {
    77     77       execsql {
    78     78   	SELECT * FROM tbl;
    79     79       }
    80     80   } {}
           81  +
           82  +# Verify that a ROLLBACK trigger works like a FAIL trigger if
           83  +# we are not within a transaction.  Ticket #3035.
           84  +#
           85  +do_test trigger3-3.3 {
           86  +    catchsql {COMMIT}
           87  +    catchsql {
           88  +        INSERT INTO tbl VALUES (3, 9, 10);
           89  +    }
           90  +} {1 {Trigger rollback}}
           91  +do_test trigger3-3.4 {
           92  +    execsql {SELECT * FROM tbl}
           93  +} {}
           94  +
    81     95   # IGNORE
    82     96   do_test trigger3-4.1 {
    83     97       catchsql {
    84     98   	BEGIN;
    85     99           INSERT INTO tbl VALUES (5, 5, 6);
    86    100           INSERT INTO tbl VALUES (4, 5, 6);
    87    101       }