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