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

[Cross-Engine] UPDATE to INNODB table with WHERE clause using Columnstore as sub query failing

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.5.3
    • 5.4.1
    • N/A
    • None
    • 2020-8

    Description

      UPDATE query to an innodb table with WHERE clause using the columnstore table as a sub query (Cross-engine query). Found that it errors as innodb table doesn't exist in Columnstore.

      Test Results:

      MariaDB [suresh]> create table cstab1 (a int, b varchar(10)) engine=columnstore;
      Query OK, 0 rows affected (0.471 sec)
       
      MariaDB [suresh]> create table innotab1 (a int, b varchar(10));
      Query OK, 0 rows affected (0.011 sec)
       
      MariaDB [suresh]> update innotab1 set a=100 where a not in (select a from cstab1 where a=1);
      ERROR 1815 (HY000): Internal error: IDB-2006: 'suresh.innotab1' does not exist in Columnstore.
      MariaDB [suresh]>
      MariaDB [suresh]> select @@version;
      +----------------+
      | @@version      |
      +----------------+
      | 10.5.5-MariaDB |
      +----------------+
      1 row in set (0.001 sec)
      

      But the same query, if we try to update an Columnstore table with WHERE clause using the innodb table as a sub query, is working.

      MariaDB [suresh]> update cstab1 set a=100 where a not in (select a from innotab1 where a=11);
      Query OK, 2 rows affected (0.366 sec)
      Rows matched: 2 Changed: 2 Warnings: 0
      

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              suresh.ramagiri@mariadb.com suresh ramagiri
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.