SQLite

Ticket Change Details
Login
Overview

Artifact ID: 71c96e66f5bbefe4f2d0b9e566625272fad14bd8bf6324214a6ea144666564d5
Ticket: f1580ba1b574e9e92d0e6c3b9de519e398e0b10e
Built-in RTRIM collating sequence yields incorrect comparisons
User & Date: drh 2019-06-14 13:25:25
Changes

  1. icomment:
    Alternative test case:
    
    <blockquote><verbatim>
    SELECT ' '<char(31) COLLATE rtrim;
    </verbatim></blockquote>
    
    The above should give and answer of true since a zero-length string is less than
    a string of length 1.  But the answer returned is false.
    
    This problem has existing in the RTRIM collating sequence since it was first
    introduced by check-in [0bf4e7fefdbbf7be] on 2008-01-20 for SQLite version 3.5.5.
    Fixed 11 years later by check-in [86fa0087cd1f5c79] 11 years later.
    
  2. login: "drh"
  3. mimetype: "text/x-fossil-wiki"
  4. priority changed to: "Immediate"
  5. resolution changed to: "Fixed"
  6. severity changed to: "Important"
  7. status changed to: "Fixed"
  8. subsystem changed to: "Unknown"
  9. title changed to:
    Built-in RTRIM collating sequence yields incorrect comparisons