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

count with distinct and 2 columns fails on every other execution

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.2.5, 1.4.1
    • 1.4.3
    • None
    • None
    • 2020-1, 2020-2

    Description

      Count with distinct and 2 columns triggers a UDAF error message on every other execution. See attached image for details.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-3738 COUNT DISTINCT should accept multiple columns

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            David.Hall David Hall (Inactive) added a comment -

            InnoDB allows for multiple params on COUNT DISTINCT, Columnstore does not.
            In ver 1.1, an appropriate error was generated. After the inclusion of the UDAF API, the code sees the multi-parameter and mistakes it for a UDAF, but the first parameter wasn't part of a UDAF, and the confusing error is generated.

            For this JIRA, I'll try to get the proper error message back. I'll also open a JIRA to enable multiple parameters for COUNT DISTINCT.

            David.Hall David Hall (Inactive) added a comment - InnoDB allows for multiple params on COUNT DISTINCT, Columnstore does not. In ver 1.1, an appropriate error was generated. After the inclusion of the UDAF API, the code sees the multi-parameter and mistakes it for a UDAF, but the first parameter wasn't part of a UDAF, and the confusing error is generated. For this JIRA, I'll try to get the proper error message back. I'll also open a JIRA to enable multiple parameters for COUNT DISTINCT.
            dleeyh Daniel Lee (Inactive) added a comment -

            Build verified: 1.4.3-1 BB nightly

            engine commit:
            f843e98

            MariaDB [mytest]> select count(distinct l_orderkey, l_linenumber) from lineitem;
            ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2020: Multiple arguments in aggregate function is currently not supported.
            MariaDB [mytest]> select count(distinct l_orderkey, l_linenumber) from lineitem;
            ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2020: Multiple arguments in aggregate function is currently not supported.
            MariaDB [mytest]> select count(distinct l_orderkey, l_linenumber) from lineitem;
            ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2020: Multiple arguments in aggregate function is currently not supported.
            MariaDB [mytest]> select count(distinct l_orderkey, l_linenumber) from lineitem;
            ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2020: Multiple arguments in aggregate function is currently not supported.

            dleeyh Daniel Lee (Inactive) added a comment - Build verified: 1.4.3-1 BB nightly engine commit: f843e98 MariaDB [mytest] > select count(distinct l_orderkey, l_linenumber) from lineitem; ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2020: Multiple arguments in aggregate function is currently not supported. MariaDB [mytest] > select count(distinct l_orderkey, l_linenumber) from lineitem; ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2020: Multiple arguments in aggregate function is currently not supported. MariaDB [mytest] > select count(distinct l_orderkey, l_linenumber) from lineitem; ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2020: Multiple arguments in aggregate function is currently not supported. MariaDB [mytest] > select count(distinct l_orderkey, l_linenumber) from lineitem; ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2020: Multiple arguments in aggregate function is currently not supported.

            People

              dleeyh Daniel Lee (Inactive)
              LinuxJedi Andrew Hutchings (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.