1
Fork 0
kantodb/testdata/sql/unimplemented/unimplemented_listen_unlisten_notify.slt

21 lines
899 B
Text

# Does not parse in generic dialect
statement error ^SQL error: ParserError\("Expected: an SQL statement, found: LISTEN at Line: 1, Column: 1"\) \(sql/xatq3n1zk65go\)$
LISTEN mychannel;
statement error ^SQL error: ParserError\("Expected: an SQL statement, found: UNLISTEN at Line: 1, Column: 1"\) \(sql/xatq3n1zk65go\)$
UNLISTEN mychannel;
statement error ^SQL error: ParserError\("Expected: an SQL statement, found: NOTIFY at Line: 1, Column: 1"\) \(sql/xatq3n1zk65go\)$
NOTIFY mychannel;
statement ok
SET sql_dialect='postgres';
statement error ^External error: unimplemented_sql/8t9hqpx4umzaq: \{ LISTEN \| UNLISTEN \| NOTIFY \}$
LISTEN mychannel;
statement error ^External error: unimplemented_sql/8t9hqpx4umzaq: \{ LISTEN \| UNLISTEN \| NOTIFY \}$
UNLISTEN mychannel;
statement error ^External error: unimplemented_sql/8t9hqpx4umzaq: \{ LISTEN \| UNLISTEN \| NOTIFY \}$
NOTIFY mychannel;