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

LP:1002108 - Wrong result (or crash) from a query with duplicated field in the group list and a limit clause

    Details

      Description

      The following test case gives us a wrong result in MariaDB 5.2/5.3/5.5:

      CREATE TABLE t1(
      col1 int,
      UNIQUE INDEX idx (col1)
      );

      INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);

      SELECT SQL_BIG_RESULT tbl1.col1 AS field1, tbl2.col1 AS field2
      FROM t1 as tbl1, t1 as tbl2
      GROUP BY field1, field2
      LIMIT 3;

      (see also bug #53534 in bugs.mysql.com)

        Attachments

          Activity

            People

            • Assignee:
              timour Timour Katchaounov (Inactive)
              Reporter:
              igor Igor Babaev
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: