Thanks for the bug report.  Now fixed on trunk and in the latest
pre-release snapshot.

https://www.sqlite.org/src/info/359725ab36339b44

On 4/20/18, Abroży Nieprzełoży <[email protected]> wrote:
> 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
> [email protected]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to