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

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • None
    • Icebox
    • DMLProc
    • None
    • 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

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