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

MySQL Bug#16314835 "WITH ROLLUP" CAUSES: DUPLICATE ENTRY 'NULL' FOR KEY '<AUTO_KEY>'

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.0.9
    • None
    • None
    • None

    Description

      The following revision doesn't seem to be merged to 10.0. Please check if it is something worthy. Found while analyzing olap.test result difference.

      revno: 5196
      		 
      committer: Guilhem Bichot <guilhem.bichot@oracle.com>
      		 
      branch nick: 5.6
      		 
      timestamp: Tue 2013-06-11 13:40:24 +0200
      		 
      message:
      		 
        Bug#16314835 "WITH ROLLUP" CAUSES: DUPLICATE ENTRY 'NULL' FOR KEY '<AUTO_KEY>'
      		 
        Bad result in 5.1/5.5, strange error in 5.6
      		 
        => disable ROLLUP+DISTINCT, with meaningful error.
      		 
        DISTINCT is often useless with GROUP BY anyway.
      		 
        Of the modified testcases, most are for internally-reported bugs.
      		 
        ROLLUP+ORDER is already disabled.

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-4784 merge test cases from 5.6

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Stalled

          Activity

            People

              Unassigned Unassigned
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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