Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3904

Group_concat order by with long double fails

Details

    • 2020-5, 2020-6, 2020-7

    Description

      A group_concat call with a subselected SUM (or AVG) in the order by phrase wil fail with
      "ERROR 1815 (HY000): Internal error: IDB-2035: An internal error occurred. Check the error log file & contact support."

      debug.log will contain "/home/calpont/mariadb/engine/utils/rowgroup/rowgroup.h@726: assertion '0' failed"

      The problem is that the order by portion of group_concat is not long double aware.

      Attachments

        Activity

          David.Hall David Hall (Inactive) created issue -
          David.Hall David Hall (Inactive) made changes -
          Field Original Value New Value
          Status Open [ 1 ] In Progress [ 3 ]
          David.Hall David Hall (Inactive) made changes -
          Assignee David Hall [ david.hall ]
          David.Hall David Hall (Inactive) made changes -
          Assignee David Hall [ david.hall ] Patrick LeBlanc [ pleblanc ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          toddstoffel Todd Stoffel (Inactive) made changes -
          Rank Ranked higher
          toddstoffel Todd Stoffel (Inactive) made changes -
          Team ColumnStore Team
          David.Hall David Hall (Inactive) made changes -
          Sprint 2020-5 [ 396 ] 2020-5, 2020-6 [ 396, 404 ]
          David.Hall David Hall (Inactive) made changes -
          Sprint 2020-5, 2020-6 [ 396, 404 ] 2020-5, 2020-6, 2020-7 [ 396, 404, 410 ]
          pleblanc Patrick LeBlanc (Inactive) made changes -
          Status In Review [ 10002 ] In Testing [ 10301 ]
          pleblanc Patrick LeBlanc (Inactive) made changes -
          Assignee Patrick LeBlanc [ pleblanc ] Daniel Lee [ dleeyh ]
          dleeyh Daniel Lee (Inactive) made changes -
          issue.field.resolutiondate 2020-05-01 20:35:01.0 2020-05-01 20:35:01.376
          dleeyh Daniel Lee (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status In Testing [ 10301 ] Closed [ 6 ]
          toddstoffel Todd Stoffel (Inactive) made changes -
          Fix Version/s 1.5.0 [ 24513 ]
          Fix Version/s 1.5 [ 22800 ]
          toddstoffel Todd Stoffel (Inactive) made changes -
          Fix Version/s 1.5.1 [ 24514 ]
          Fix Version/s 1.5.0 [ 24513 ]
          mariadb-jira-automation Jira Automation (IT) made changes -
          Zendesk Related Tickets 166960

          People

            dleeyh Daniel Lee (Inactive)
            David.Hall David Hall (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.