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

exemgr crashes with a nested aggregate multiplication query

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 1.0.11
    • 1.0.12, 1.1.1
    • MDB Plugin
    • None
    • 2017-18, 2017-19, 2017-20, 2017-21

    Description

      The following table and query will cause exemgr to crash and not return results (happens whether the table has no rows or any values)

      CREATE TABLE test.test (
      id INT,
      integerfield int
      ) ENGINE=Columnstore;
       
      SELECT id,
      kpi1
      FROM  (SELECT id,
                  ((SUM(integerfield))/
                   (SUM(integerfield))
                  )*100 kpi1
             FROM   test.test
             GROUP BY id) kpi
      WHERE  kpi1 IS NOT NULL;
      

      Removing either the *100 in the subquery or where kpi1 is not null causes the query to work.

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            dthompson David Thompson (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            5 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.