chai
chai copied to clipboard
INSERT: If the schema is strict and we are explicitly specifying more fields than expected, we should return an error
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