/ Ticket Change Details
Login
Overview

Artifact ID: c83cd179b0254e660c0d7bb474d4e0abf99dece2d746e0f889d042f084440182
Ticket: fb8c538a8f57ae2a69540a293141dcc9dfb832b5
Incorrect sorting when a column uses BINARY collation in the ORDER BY, but is constrained by an == with a different collation in the WHERE clause
User & Date: dan 2020-02-12 06:21:39
Changes

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

    Example:

      CREATE TABLE t1(b COLLATE nocase);
      INSERT INTO t1 VALUES('abc');
      INSERT INTO t1 VALUES('ABC');
      INSERT INTO t1 VALUES('aBC');
    
      -- correctly returns: "ABC aBC abc"
      SELECT * FROM t1 ORDER BY b COLLATE binary;
    
      -- incorrectly omits external sort and returns: "abc ABC aBC"
      SELECT * FROM t1 WHERE b='abc' ORDER BY b COLLATE binary;
    
  3. Change login to "dan"
  4. Change mimetype to "text/x-fossil-wiki"
  5. Change severity to "Minor"
  6. Change status to "Open"
  7. Change title to:

    Incorrect sorting when a column uses BINARY collation in the ORDER BY, but is constrained by an == with a different collation in the WHERE clause

  8. Change type to "Code_Defect"