SQLite

View Ticket
Login
Ticket Hash: b92e5e8ec2cdbaa1d6dde8b3b2ae2d8a659a8d3d
Title: Query on table without rows and generated column results in "out of memory" error
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-08 00:06:54
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-07 14:11:20:

Consider the following statements:

CREATE TABLE t0(c0 AS (1), c1);
CREATE TABLE t1(c0);
SELECT * FROM t0, t1 WHERE t0.c0 == 0; -- out of memory

Unexpectedly, the query results in an out-of-memory error.