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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.