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

10 lines
394 B
Text
Raw Permalink Normal View History

2025-03-27 13:45:43 -06:00
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());