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

1.4 group by order error - Internal error: IDB-2021: 'ref_genome' is not in GROUP BY clause

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.4.2
    • 1.4.3-5, 1.4.4, 1.5.1
    • None
    • None
    • 1um 4 pm

    Description

      Customer reported error and Support was able to reproduce on a single server system running 1.4.2. It as customer reported, it did successfully work on 1.2.5.

      This issue is within the new 1.4.2 Columnstore/Server instance that does not occur on 1.2.5 Columnstore.

      The group by order seems to be handled differently now. Both 1.4.2 and 1.2.5 instances tables are the same, but when the same query is run, it errors on 1.4.2 only.

      Data will be in the next comments as confidential

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Gregory Dorman (Inactive) made transition -
          Open Confirmed
          		50d 2h 26m 1
          Jose Rojas (Inactive) made transition -
          Confirmed In Progress
          		15m 14s 1
          Jose Rojas (Inactive) made transition -
          In Progress In Testing
          		4s 1
          Daniel Lee (Inactive) made transition -
          In Testing Closed
          		28d 19h 20m 1

          People

            dleeyh Daniel Lee (Inactive)
            hill David Hill (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.