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/select/test_select_locking.test
# description: Select locking
# group: [select]
statement ok
CREATE TABLE t (t TEXT);
# unsupported
statement error
SELECT * FROM t FOR UPDATE;
----
<REGEX>:.*Parser Error.*SELECT locking clause is not supported.*
# unsupported
statement error
SELECT * FROM t FOR NO KEY UPDATE;
----
<REGEX>:.*Parser Error.*SELECT locking clause is not supported.*
# unsupported
statement error
SELECT * FROM t FOR SHARE;
----
<REGEX>:.*Parser Error.*SELECT locking clause is not supported.*
# unsupported
statement error
SELECT * FROM t KEY SHARE;
----
<REGEX>:.*Parser Error.*syntax error.*
|