Re: [sqlite] 'replace ... do update...' crash

[Richard Hipp]

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  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
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] 'replace ... do update...' crash

[Abroży Nieprzełoży]

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