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