[MCOL-4214] Show more meaningful error message when cross-engine support is not configured Created: 2020-07-27  Updated: 2023-10-26  Resolved: 2023-10-26

Status: Closed
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: susil.behera Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

Server version: 10.5.4-MariaDB MariaDB Server
Columnstore: 1.5.2-1



 Description   

To perform write operations like UPDATE/DELETE on a columnstore table by referencing to an Inndb table one needs cross-engine configuration. But if someone tries without it the error message is not suggesting anything about the required configuration.

On a setup without cross-engine configuration>
CREATE TABLE t_cs (a INT, b INT) ENGINE=Columnstore;
CREATE TABLE t_innodb (a INT, b INT) ENGINE=Innodb;

UPDATE t_cs SET b=(SELECT b FROM t_innodb LIMIT 1);
ERROR 1815 (HY000): Internal error: CAL0002: Update Failed: ExeMgr Error 8002

DELETE FROM t_cs WHERE b=(SELECT b FROM t_innodb LIMIT 1);
ERROR 1815 (HY000): Internal error: CAL0002: Delete Failed: Error from ExeMgr 30

The error msgs should be suggesting the actual problem.


Generated at Thu Feb 08 02:48:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.