20 lines
425 B
Text
20 lines
425 B
Text
statement ok
|
|
CREATE TABLE kanto.myschema.mytable (a INTEGER);
|
|
|
|
statement ok
|
|
INSERT INTO kanto.myschema.mytable VALUES (13), (42);
|
|
|
|
query I rowsort
|
|
SELECT * FROM kanto.myschema.mytable;
|
|
----
|
|
13
|
|
42
|
|
|
|
#statement ok
|
|
statement error ^External error: unimplemented/gs5muy13tu1uk: cannot delete from row_id tables yet$
|
|
DELETE FROM kanto.myschema.mytable WHERE a=42;
|
|
|
|
#query I rowsort
|
|
#SELECT * FROM kanto.myschema.mytable;
|
|
#----
|
|
#13
|