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

exemgr crashes with a nested aggregate multiplication query

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.0.11
    • Fix Version/s: 1.0.12, 1.1.1
    • Component/s: Connector
    • Labels:
      None
    • Sprint:
      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

            Assignee:
            dleeyh Daniel Lee
            Reporter:
            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.