tcl onecolumn command with constraint violation
(1) By anonymous on 2021-08-08 09:56:56 [source]
No error is raised by onecolumn:
% load /usr/lib/sqlite3.36.0/libtclsqlite3.so
% sqlite3 db1
% db1 eval {CREATE TABLE items (id INTEGER PRIMARY KEY);}
% db1 eval {CREATE TABLE trades (item INTEGER REFERENCES items(id) NOT NULL);}
% db1 onecolumn {INSERT INTO trades (item) VALUES (42) RETURNING *}
42
But:
% db1 eval {INSERT INTO trades (item) VALUES (42) RETURNING *}
FOREIGN KEY constraint failed
Could you please advise ?
Thanks.