aboutsummaryrefslogtreecommitdiff
path: root/test/trigger9.test
diff options
context:
space:
mode:
authordan <Dan Kennedy>2024-03-19 15:27:15 +0000
committerdan <Dan Kennedy>2024-03-19 15:27:15 +0000
commitf891ef8d6111c8c8aa7de74bcd36aaf2f4569c47 (patch)
treedd7c6b579f751efb065bb88eefca846fb4046cd9 /test/trigger9.test
parent967c3032124b1365c65946371809660404376169 (diff)
downloadsqlite-f891ef8d6111c8c8aa7de74bcd36aaf2f4569c47.tar.gz
sqlite-f891ef8d6111c8c8aa7de74bcd36aaf2f4569c47.zip
Update tests to work with SQLITE_ALLOW_ROWID_IN_VIEW.
FossilOrigin-Name: 495b8c7b08b998ddfe2ad055703f058c768e7e94014952e5cd8a81c7c1515cb1
Diffstat (limited to 'test/trigger9.test')
-rw-r--r--test/trigger9.test27
1 files changed, 21 insertions, 6 deletions
diff --git a/test/trigger9.test b/test/trigger9.test
index 6e31d1af9..47940de57 100644
--- a/test/trigger9.test
+++ b/test/trigger9.test
@@ -242,12 +242,27 @@ do_execsql_test 4.1 {
END;
}
-do_catchsql_test 4.2 {
- DELETE FROM v1 WHERE rowid=1;
-} {1 {no such column: rowid}}
+ifcapable !allow_rowid_in_view {
+ do_catchsql_test 4.2 {
+ DELETE FROM v1 WHERE rowid=1;
+ } {1 {no such column: rowid}}
-do_catchsql_test 4.3 {
- UPDATE v1 SET a=b WHERE rowid=2;
-} {1 {no such column: rowid}}
+ do_catchsql_test 4.3 {
+ UPDATE v1 SET a=b WHERE rowid=2;
+ } {1 {no such column: rowid}}
+} else {
+ do_execsql_test 4.2a {
+ DELETE FROM log;
+ }
+ do_catchsql_test 4.2 {
+ DELETE FROM v1 WHERE rowid=1;
+ } {0 {}}
+ do_catchsql_test 4.3 {
+ UPDATE v1 SET a=b WHERE rowid=2;
+ } {0 {}}
+ do_execsql_test 4.3b {
+ SELECT * FROM log;
+ }
+}
finish_test