aboutsummaryrefslogtreecommitdiff
path: root/test/savepoint.test
diff options
context:
space:
mode:
authordrh <drh@noemail.net>2017-08-01 00:20:34 +0000
committerdrh <drh@noemail.net>2017-08-01 00:20:34 +0000
commite9e1074d27e03e3a54f6547251923b27d7e8b51b (patch)
tree7db3870b1e90075b4f9c7ca2a21f2ecafc0c6ef1 /test/savepoint.test
parent334d163e416c910bf2274d56f3024bb04113ff2b (diff)
parentcf201488a52f4a000881c894c881ac15bfad8ef9 (diff)
downloadsqlite-e9e1074d27e03e3a54f6547251923b27d7e8b51b.tar.gz
sqlite-e9e1074d27e03e3a54f6547251923b27d7e8b51b.zip
Allow ATTACH and DETACH inside of a transaction.
FossilOrigin-Name: 95e8f31658254dd2df3eeaae337aff0fe2125d170ae966c74f4fc70400e099b1
Diffstat (limited to 'test/savepoint.test')
-rw-r--r--test/savepoint.test9
1 files changed, 7 insertions, 2 deletions
diff --git a/test/savepoint.test b/test/savepoint.test
index 8055e61d9..eed8a9e70 100644
--- a/test/savepoint.test
+++ b/test/savepoint.test
@@ -616,12 +616,16 @@ ifcapable auth {
# First make sure it is not possible to attach or detach a database while
# a savepoint is open (it is not possible if any transaction is open).
#
+# UPDATE 2017-07-26: It is not possible to ATTACH and DETACH within a
+# a transaction.
+#
do_test savepoint-10.1.1 {
catchsql {
SAVEPOINT one;
ATTACH 'test2.db' AS aux;
+ DETACH aux;
}
-} {1 {cannot ATTACH database within transaction}}
+} {0 {}}
do_test savepoint-10.1.2 {
execsql {
RELEASE one;
@@ -630,8 +634,9 @@ do_test savepoint-10.1.2 {
catchsql {
SAVEPOINT one;
DETACH aux;
+ ATTACH 'test2.db' AS aux;
}
-} {1 {cannot DETACH database within transaction}}
+} {0 {}}
do_test savepoint-10.1.3 {
execsql {
RELEASE one;