Index: test/trigger3.test ================================================================== --- test/trigger3.test +++ test/trigger3.test @@ -76,10 +76,24 @@ 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);