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

GROUP BY doesn't process IN + correlate subquery.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.2.2
    • Fix Version/s: 1.4.3
    • Component/s: Connector
    • Labels:
      None
    • Sprint:
      2018-20, 2018-21, 2019-01, 2019-02, 2019-03, 2019-04, 2019-05, 2019-06

      Description

      ATM GROUP by failes to process the query:

      MariaDB [test]>  select sum(i) from cs2 where cs2.i in ( select i from cs3 );
      ERROR 1815 (HY000): Internal error: IDB-1000: 'cs2' and 'cs3' are not joined.
      

      Internally optimizer sends a number of filter predicates that I asked an optimizer team about:

      (gdb) p query->where
      $1 = (Item_int *) 0x7f4570019af8
      (gdb) p query->where->next
      $2 = (Item_equal *) 0x7f4570017970
      (gdb) p query->where->next->next
      $3 = (Item_cond_and *) 0x7f4570017838         
      (gdb) p query->from->select_lex->cond_count 
      $4 = 2
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              drrtuy Roman
              Reporter:
              drrtuy Roman
              Votes:
              1 Vote for this issue
              Watchers:
              2 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.