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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-2147 Semi-join with correllated subquery case .. when ... end in the join key.

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MCOL-1716 GROUP BY handler incorrectly process filters with subquery as IN predicate

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-2165 Autoswitch broken in some cases in 1.2.2

          • Major - Major loss of function.
          • Closed

            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.