/ 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. Change icomment to:

    Alternative test case:

    SELECT ' '<char(31) COLLATE rtrim;
    

    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. Change login to "drh"
  3. Change mimetype to "text/x-fossil-wiki"
  4. Change priority to "Immediate"
  5. Change resolution to "Fixed"
  6. Change severity to "Important"
  7. Change status to "Fixed"
  8. Change subsystem to "Unknown"
  9. Change title to:

    Built-in RTRIM collating sequence yields incorrect comparisons