Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8742

Wrong result for SELECT..WHERE view_latin1_swedish_ci_field='a' COLLATE latin1_bin

    Details

      Description

      DROP TABLE IF EXISTS t1;
      CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET latin1);
      INSERT INTO t1 VALUES ('a'),('A');
      DROP VIEW IF EXISTS v1;
      CREATE VIEW v1 AS SELECT * FROM t1 WHERE a='a';
      SELECT * FROM v1 WHERE a=_latin1'a' COLLATE latin1_bin;

      erroneously returns two rows:

      +------+
      | a    |
      +------+
      | a    |
      | A    |
      +------+

      The expected result is to return on row only, with 'a' in lower case.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                bar Alexander Barkov
                Reporter:
                bar Alexander Barkov
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: