sqlite> .version
SQLite 3.24.0 2018-04-20 18:01:31
279c48f6061f766f5437edd6964c0dd1e10399314eb17b6e5ee34df925a7alt1
zlib version 1.2.11
msvc-1912
CREATE TABLE abc(
a TEXT UNIQUE,
b TEXT UNIQUE
);
CREATE TABLE tt(
id INTEGER PRIMARY KEY AUTOINCREMENT,
x TEXT
);
CREATE TRIGGER bef_ins BEFORE INSERT ON abc BEGIN INSERT INTO tt(x)
VALUES('bi'); END;
INSERT INTO abc(a, b) VALUES('X', 'Y'),('1', '2');
REPLACE INTO abc(a, b) VALUES('X', 'Z'),('9', '2') ON CONFLICT(b) DO
UPDATE SET b='8'; --crash
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
