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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.5.3
    • Fix Version/s: 5.4.1
    • Component/s: N/A
    • Labels:
      None
    • Sprint:
      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

          Activity

            People

            Assignee:
            dleeyh Daniel Lee
            Reporter:
            suresh.ramagiri@mariadb.com suresh ramagiri
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration