Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.5.3
-
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
- relates to
-
-
- Open
-