17 lines
529 B
Text
17 lines
529 B
Text
statement ok
|
|
CREATE TABLE kanto.myschema.mytable (a BIGINT NOT NULL, b BIGINT, PRIMARY KEY(a));
|
|
|
|
statement ok
|
|
INSERT INTO kanto.myschema.mytable (a, b) VALUES (42, 7), (13, 34);
|
|
|
|
###TODO should we support updating primary key; survey
|
|
#statement ok
|
|
#UPDATE kanto.myschema.mytable SET a=41 WHERE b=7;
|
|
#
|
|
#query II
|
|
#SELECT * FROM kanto.myschema.mytable ORDER BY a;
|
|
#----
|
|
#13 34
|
|
#41 7
|
|
statement error ^External error: unimplemented_sql/fpb157cronqcy: UPDATE of column in primary key$
|
|
UPDATE kanto.myschema.mytable SET a=41 WHERE b=7;
|