SQLite Forum

Crash when a RETURNING clause refers to a table in UPDATE FROM
Thanks for the simplified test case.

> Does the returning clause permit returning values not from the updated table?

One would think not. But PostgreSQL apparently does. It's unclear whether that makes any sense or is an implementation artifact.