17 lines
616 B
Text
17 lines
616 B
Text
statement ok
|
|
CREATE TABLE kanto.myschema.mytable (mycolumn BIGINT NOT NULL, PRIMARY KEY(mycolumn));
|
|
|
|
statement ok
|
|
INSERT INTO kanto.myschema.mytable (mycolumn) VALUES (42), (13);
|
|
|
|
#query II rowsort
|
|
#DELETE kanto.myschema.mytable (mycolumn) WHERE 1<>2
|
|
# RETURNING 1+1 AS two, mycolumn-10 AS b;
|
|
#----
|
|
#2 4
|
|
#2 33
|
|
|
|
# DataFusion does not support `DELETE RETURNING` (#ref/yn84qzsk1f9ny) #ecosystem/datafusion #severity/high #urgency/medium
|
|
statement error ^Error during planning: Delete-returning clause not yet supported$
|
|
DELETE kanto.myschema.mytable (mycolumn) WHERE 1<>2
|
|
RETURNING 1+1 AS two, mycolumn-10 AS b;
|