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

UDAF incorrect error on some joins

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.1.0
    • 1.1.3
    • ExeMgr
    • None
    • 2017-20, 2017-21, 2017-22, 2017-23, 2017-24, 2017-25, 2018-01, 2018-02, 2018-03

    Description

      The following query should return a valid value. It creates an error:

      MariaDB [ssb]> select
      -> ssq(lo_linenumber)
      -> from (select lo_linenumber, lo_custkey
      -> from lineorder where lo_custkey in (29998,29999,30000)) a,
      -> customer where c_custkey = lo_custkey;
      ERROR 1815 (HY000): Internal error: An unexpected condition within the query caused an internal processing error within InfiniDB. Please check the log files for more details. Additional Information: error in TupleAggregateStep.
      MariaDB [ssb]>

      The problem appears to be that when processing a large dataset in this particular case, one rowgroup is left on a queue and is processed without the user data. I have checked and it appears all the PM processing is correct.

      Attachments

        Activity

          People

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