SQLite

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. foundin changed to: "3.10.0"
  2. icomment:
    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.
    
  3. login: "drh"
  4. mimetype: "text/x-fossil-wiki"
  5. severity changed to: "Critical"
  6. status changed to: "Open"
  7. title changed to: "Incorrect case folding in the LIKE operator"
  8. type changed to: "Code_Defect"