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

    XMLWordPrintable

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

          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:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 1h
                1h

                Git Integration

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