/ Ticket Change Details
Login
Overview

Artifact ID: b3016558c5282cc79787674cb650e0dfd127105f
Ticket: 80369eddd5c94d49f7fbbcf5d442bac618549aa7
Incorrect case folding in the LIKE operator
User & Date: drh 2016-01-20 14:07:10
Changes

  1. Change foundin to "3.10.0"
  2. Change icomment to:

    The following (equivalent) queries return true, when the correct answer is false:

    SELECT 'き' LIKE 'ね';
    SELECT char(0x304d) LIKE char(0x306d);
    

    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.

  3. Change login to "drh"
  4. Change mimetype to "text/x-fossil-wiki"
  5. Change severity to "Critical"
  6. Change status to "Open"
  7. Change title to "Incorrect case folding in the LIKE operator"
  8. Change type to "Code_Defect"