1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
# name: test/sql/transactions/test_create_drop_conflict.test
# description: Test a conflict with create/drop across transactions
# group: [transactions]
load __TEST_DIR__/broken.db
statement ok
CREATE SCHEMA foo;
statement ok con2
START TRANSACTION;
# Drop the schema in con2
statement ok con2
DROP SCHEMA IF EXISTS foo CASCADE;
# Create a table on the schema we're dropping
# This should succeed because the schema drop isn't committed yet
statement ok con1
create table foo.bar as select 42;
# This now fails because the 'create table' was committed
statement error con2
COMMIT;
----
Could not commit DROP
statement ok
DROP SCHEMA foo CASCADE;
|
