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

UDAF returns null for 2nd or more applications against same column

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.1.0
    • 1.1.1
    • None
    • None
    • 2017-19, 2017-20, 2017-21

    Description

      to reproduce:

      create table s1(i1 int, i2 int) engine=columnstore;
      insert into s1 values (1,2), (3,4);
      select median(i1), avg_mode(i1) from s1;
      +------------+--------------+
      | median(i1) | avg_mode(i1) |
      +------------+--------------+
      |          2 |         NULL |
      +------------+--------------+
      1 row in set (0.01 sec)
      

      doesn't matter the order or function but when you have multiple udafs applied to the same column the ones after the first ones return null

      Attachments

        Activity

          People

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