aboutsummaryrefslogtreecommitdiff
path: root/test/table.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/table.test')
-rw-r--r--test/table.test19
1 files changed, 19 insertions, 0 deletions
diff --git a/test/table.test b/test/table.test
index 69f105aa6..faa9712bf 100644
--- a/test/table.test
+++ b/test/table.test
@@ -272,6 +272,25 @@ do_test table-5.2.1 {
}
} {}
+do_test table-5.2.2 {
+ db close
+ forcedelete test.db
+ sqlite3 db test.db
+ db eval {
+ CREATE TABLE t0(a,b);
+ CREATE INDEX t ON t0(a);
+ PRAGMA writable_schema=ON;
+ UPDATE sqlite_master SET sql='CREATE TABLE a.b(a UNIQUE';
+ BEGIN;
+ CREATE TABLE t1(x);
+ ROLLBACK;
+ DROP TABLE IF EXISTS t99;
+ }
+} {}
+db close
+forcedelete test.db
+sqlite3 db test.db
+
# Make sure an EXPLAIN does not really create a new table
#
do_test table-5.3 {