| Ticket Hash: | 80369eddd5c94d49f7fbbcf5d442bac618549aa7 | |||
| Title: | Incorrect case folding in the LIKE operator | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Critical | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2016-01-20 14:25:16 | |||
| Version Found In: | 3.10.0 | |||
| User Comments: | ||||
drh added on 2016-01-20 14:07:10:
(text/x-fossil-wiki)
The following (equivalent) queries return true, when the correct answer is false: <blockquote><verbatim> SELECT 'き' LIKE 'ね'; SELECT char(0x304d) LIKE char(0x306d); </verbatim></blockquote> The culprit seems to be check-in [0a99a8c4facf] on [2015-12-30 14:06:22]. Case comparison is only looking at the lower 8 bytes of unicode values. | ||||