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

    XMLWordPrintable

    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: