chai icon indicating copy to clipboard operation
chai copied to clipboard

INSERT: If the schema is strict and we are explicitly specifying more fields than expected, we should return an error

Open asdine opened this issue 2 years ago • 0 comments

CREATE TABLE foo(a, b);
INSERT INTO foo(a, b, c) VALUES (1, 2, 3);
-- error

-- this notation is fine, it allows inserting large documents but only keeping the ones
-- interested in
INSERT INTO foo VALUES {a: 1, b: 2, c: 3};
-- NO ERROR

asdine avatar Jul 03 '22 02:07 asdine