SQLite

View Ticket
Login
Ticket Hash: 8c63ff0eca81a9132d8d67b31cd6ae9712a2cc6f
Title: Incorrect query result on a UNION ALL
Status: Fixed Type: Code_Defect
Severity: Severe Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2014-02-25 21:56:00
Version Found In: 3.8.3.1
User Comments:
drh added on 2014-02-25 18:46:01: (text/x-fossil-wiki)
Temp registers can sometimes be used in concurrent co-routines, resulting in a
incorrect answer.  The attached script demonstrations one manifestation of this.
The attachment fails with any check-in after the introduction of the NGQP.
But the register allocation problem predates that change.  The cut-over of the
NGQP only makes the attached test case work.  Probably other test cases can be
made to fail for versions prior to the NGQP.

Attachments: