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