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

Wrong results with MAKE_SET() and subquery

    Details

      Description

      This problem is similar to MDEV-10306.

      This script:

      SET optimizer_switch=_utf8'derived_merge=on';
      DROP TABLE IF EXISTS t1;
      CREATE TABLE t1 (t VARCHAR(10) CHARSET latin1);
      INSERT INTO t1 VALUES('abcdefghi');
      SELECT CONCAT(t2,'-',t2) c2 FROM (SELECT MAKE_SET(3,t,t) t2 FROM t1) sub;
      

      returns a wrong result:

      +----------------------------------------+
      | c2                                     |
      +----------------------------------------+
      | abcdefghi,abcdefghiabcdefghi,abcdefghi |
      +----------------------------------------+
      

      Notice, there is no the expected dash character in the result.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: