/ View Ticket
Login
Ticket Hash: f3ff1472887cfba391c43de51ac2ea4a1761c9ee
Title: Incorrect result for IN expression with right-hand IS TRUE sub-expression
Status: Closed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2020-08-24 10:53:55
Version Found In:
User Comments:
mrigger added on 2020-08-24 08:17:32: (text/x-fossil-wiki)
The following expression unexpectedly evaluates to FALSE:

<code>
SELECT (1 IN (2 IS TRUE)); -- expected: {1}, actual: {0}
</code>

I found this based on commit [5f58dd3a19] and SQLancer's PQS implementation. It seems that this bug was introduced by commit [27936e6884].

dan added on 2020-08-24 10:53:55: (text/x-markdown)
Fixed by [493a2594].