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

GROUP BY doesn't process NOT IN + correlate subquery with aggregates

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.2.2
    • 1.4.3
    • MDB Plugin
    • None
    • 2018-20, 2018-21, 2019-01, 2019-02, 2019-03, 2019-04, 2019-05, 2019-06

    Description

      The query

      MariaDB [test]> set infinidb_vtable_mode=1;
      Query OK, 0 rows affected (0.000 sec)

      MariaDB [test]> select sum from cs2 where cs2.i not in ( select sum from cs3 );
      --------

      sum

      --------

      66

      --------
      1 row in set (0.057 sec)

      MariaDB [test]> set infinidb_vtable_mode=0;
      Query OK, 0 rows affected (0.000 sec)

      MariaDB [test]> select sum from cs2 where cs2.i not in ( select sum from cs3 );
      ERROR 1815 (HY000): Internal error: IDB-1001: Function 'trigcond' can only be used in the outermost select or order by clause and cannot be used in conjunction with an aggregate function.

       

      Attachments

        Issue Links

          Activity

            People

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