| Ticket Hash: | dbaf8a6820be1ece7e48a6b92febcaba39076f3b | |||
| Title: | Unexpected affinity conversion is performed for the IN operator | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Important | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2019-08-27 17:01:25 | |||
| Version Found In: | 3.29.0 | |||
| User Comments: | ||||
|
mrigger added on 2019-08-27 15:14:50:
Unexpectedly, in the test case below, a row is fetched that should not be fetched: CREATE TABLE t0(c0 INT UNIQUE); INSERT INTO t0(c0) VALUES (1); SELECT * FROM t0 WHERE '1' IN (t0.c0); -- unexpected: fetches row The WHERE condition should yield FALSE, as demonstrated by the following statement: SELECT '1' IN (t0.c0) FROM t0; -- expected: 0 When removing the UNIQUE constraint on the column, the query works as expected. | ||||