| Ticket Hash: | 80e031a00f45dca877ed92b225209cfa09280f4f | ||
| Title: | Result of IN should never be NULL if the RHS is empty | ||
| Status: | Fixed | Type: | Code_Defect |
| Severity: | Important | Priority: | Immediate |
| Subsystem: | Code_Generator | Resolution: | Fixed |
| Last Modified: |
2010-07-14 18:24:26 14.99 years ago |
Created: |
2010-07-14 15:48:48 14.99 years ago |
| Version Found In: | 3.6.23.1 | ||
| Description: | ||||
| When the right-hand side (RHS) of an IN or NOT IN operator is an empty set, then the result should always be false or true, respectively, even if the left hand operand is NULL. The current (incorrect) behavior of SQLite is to always yield a NULL result if the left operand is NULL. | ||||