View Ticket
Ticket UUID: 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:
User Comments:
drh added on 2014-02-25 18:46:01:

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.