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

14 lines
557 B
Text

statement ok
CREATE TABLE kanto.myschema.mytable (mycolumn BIGINT NOT NULL, PRIMARY KEY(mycolumn));
#query II rowsort
#INSERT INTO kanto.myschema.mytable (mycolumn) VALUES (42), (13)
# RETURNING 1+1 AS two, mycolumn-10 AS b;
#----
#2 3
#2 32
# DataFusion does not support `INSERT RETURNING` (#ref/hixyde6h9n77o) #ecosystem/datafusion #severity/high #urgency/medium
statement error ^Error during planning: Insert-returning clause not supported$
INSERT INTO kanto.myschema.mytable (mycolumn) VALUES (42), (13)
RETURNING 1+1 AS two, mycolumn-10 AS b;