| 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 4.87 years ago |
Created: |
2020-08-24 08:17:32 4.87 years ago |
| 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]. | ||||