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

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.0.9
    • Fix Version/s: 10.0
    • Component/s: None
    • Labels:
      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

            Activity

              People

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

                Dates

                Created:
                Updated: