Overview
Artifact ID: | 71c96e66f5bbefe4f2d0b9e566625272fad14bd8bf6324214a6ea144666564d5 |
---|---|
Ticket: | f1580ba1b574e9e92d0e6c3b9de519e398e0b10e
Built-in RTRIM collating sequence yields incorrect comparisons |
User & Date: | drh 2019-06-14 13:25:25 |
Changes
- 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.
- login: "drh"
- mimetype: "text/x-fossil-wiki"
- priority changed to: "Immediate"
- resolution changed to: "Fixed"
- severity changed to: "Important"
- status changed to: "Fixed"
- subsystem changed to: "Unknown"
- title changed to:
Built-in RTRIM collating sequence yields incorrect comparisons