1
Fork 0
kantodb/testdata/sql/create_table_without_primary_key.slt

9 lines
394 B
Text

statement ok
CREATE TABLE mytable (mycolumn BIGINT);
statement ok
INSERT INTO mytable (mycolumn) VALUES (42), (13);
# Ensure that this is a parser error, and should never reach to index creation (see #y1p3dtjgiwpaw).
statement error ^SQL error: ParserError\("Expected: identifier, found: \) at Line: 1, Column: \d+"\) \(sql/xatq3n1zk65go\)$
CREATE TABLE two (mycolumn BIGINT, PRIMARY KEY());