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

LP:792338 - Bogus result with SQL_BIG_RESULT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Not a Bug
    • None
    • None
    • None

    Description

      The following query returns a totally bogus result – the rows returned can not be found in the original table.

      CREATE TABLE t1 ( f1 int NOT NULL , PRIMARY KEY (f1)) ;
      INSERT IGNORE INTO t1 VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20);
      SELECT SQL_BIG_RESULT f1 AS field1 , f1 AS field2
      FROM t1
      GROUP BY field1 , field2 ;

      correct result:

      SELECT f1 AS field1 , f1 AS field2
      FROM t1
      GROUP BY field1 , field2 ;

      Attachments

        Activity

          People

            Unassigned Unassigned
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.