View Ticket
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:

The following expression unexpectedly evaluates to FALSE:

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

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:

Fixed by [493a2594].