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

Show more meaningful error message when cross-engine support is not configured

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Icebox
    • Component/s: DMLProc
    • 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.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            susil.behera susil.behera
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.