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

Cartesian product should be supported

    XMLWordPrintable

Details

    Description

      mysql> create table t2_c(c1 int) engine=columnstore;
      Query OK, 0 rows affected (0.41 sec)

      mysql> create table t1_c(c1 int) engine=columnstore;
      Query OK, 0 rows affected (0.46 sec)

      mysql> select t1_c.* from t1_c join t2_c;
      ERROR 1815 (HY000): Internal error: IDB-1000: 't1_c' and 't2_c' are not joined.

      Needed for TPC-DS

      Attachments

        Issue Links

          causes

          New Feature - A new feature of the product, which has yet to be developed. MCOL-5764 Disk-based Cartesian JOIN

          • Major - Major loss of function.
          • Open
          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. MCOL-1030 support non equality based joins and correlated subqueries

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-1620 Update with subquery treated as unsupported cartesian join, but multi-table update works

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MCOL-4307 View with a query containing a cartesian join silently fails

          • Major - Major loss of function.
          • Open

          Activity

            People

              denis0x0D Denis Khalikov
              jswanhart Justin Swanhart (Inactive)
              Votes:
              6 Vote for this issue
              Watchers:
              18 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.