17 lines
642 B
Text
17 lines
642 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
|
|
#UPDATE kanto.myschema.mytable (mycolumn) SET mycolumn=mycolumn+1
|
|
# RETURNING 1+1 AS two, mycolumn-10 AS b;
|
|
#----
|
|
#2 4
|
|
#2 33
|
|
|
|
# DataFusion does not support `UPDATE RETURNING` (#ref/pp5wz7nq4yhzs) #ecosystem/datafusion #severity/high #urgency/medium
|
|
statement error ^Error during planning: Update-returning clause not yet supported$
|
|
UPDATE kanto.myschema.mytable (mycolumn) SET mycolumn=mycolumn+1
|
|
RETURNING 1+1 AS two, mycolumn-10 AS b;
|