SQLite

This SQL, applied to :memory: DB, CREATE TABLE a (id INTEGER NOT NULL PRIMARY KEY); UPDATE a SET id = a.id + 1 FROM (SELECT * FROM a) AS old RETURNING old.*; produces a seg-fault at line 99948 of sqlite3.c .

Reported in forum post: https://sqlite.org/forum/forumpost/cdc28fec1a

Slightly simpler test case (from Keith at the forum): create table x(a,b); create table y(c,d); update x set a=c from y where b=d returning *;

Strike that final repro update. Both of these seg-fault: update x set a=c from y where b=d returning x.*; update x set a=c from y where b=d returning y.*; . And, interestingly, this does not: update x set a=c from y where b=d returning x.a, y.d; , instead producing: "Error: no such column: y.d". (All lifted from Keith's post.)

The FROM clause is not required. Any RETURNING that contains the form "table.*" seems to cause the problem. Example:

CREATE TABLE t1(x);
INSERT INTO t1 VALUE(1) RETURNING t1.*;