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.
|