/ View Ticket
Login
Ticket UUID: 490a4b723562429807f13842ab2536997cca2491
Title: "WHERE 0" on the first element of a UNION causes an assertion fault
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2013-07-09 03:04:50
Version Found In: 3.7.17
User Comments:
drh added on 2013-07-09 02:24:58: (text/x-fossil-wiki)
The following SQL script results in an assertion fault:

<blockquote><verbatim>
CREATE TABLE abc(a,b,c); INSERT INTO abc VALUES(1,2,3);
CREATE TABLE def(d,e,f); INSERT INTO def VALUES(3,4,5);
SELECT * FROM abc WHERE 0 UNION SELECT * FROM def;
</verbatim></blockquote>

This bug appears to have been in the code essentially forever.  Incorrect
VDBE code has been generated since version 3.3.7 (circa 2006) and prior to
that the code generator segfaults.