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
|
# name: test/sql/table_function/sqlite_master_connections.test
# description: Use the internal sqlite_master view from different tables
# group: [table_function]
statement ok con1
BEGIN TRANSACTION
statement ok con2
BEGIN TRANSACTION
statement ok con1
SELECT * FROM sqlite_master;
statement ok con2
SELECT * FROM sqlite_master;
statement ok con1
ROLLBACK
statement ok con2
ROLLBACK
statement ok
SELECT * FROM sqlite_master;
statement error
DROP VIEW sqlite_master
----
<REGEX>:.*Catalog Error.*Cannot drop internal catalog entry.*
|