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

Cannot execute query on mixed engine tables

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.0.6.1
    • 1.0.7
    • ExeMgr
    • None
    • Columnstore 1.0.6-1 in Docker container (CentOS 7); host is Fedora 25
    • 2017-01

    Description

      Columnstore is configured in my.cnf with:

      infinidb_vtable_mode = 2
      infinidb_compression_type = 2
      ...

      and in Columnstore.xml with

      <CrossEngineSupport>
      <Host>localhost</Host>
      <Port>3306</Port>
      <User>root</User>
      <Password/>
      </CrossEngineSupport>

      root has no password on localhost, as default.

      Given the following mixed-engine structure:

      create database testDB DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
      use testDB;

      CREATE TABLE `idb_expr` (
      `id` BIGINT NOT NULL ,
      `repositoryid` VARCHAR(255) NOT NULL,
      `code` LONGTEXT NOT NULL,
      `expression` LONGTEXT NOT NULL,
      `hash` BIGINT NOT NULL,
      PRIMARY KEY (`id`),
      KEY `idb_expr_idx_1` (`repositoryid`,`hash`)
      ) ENGINE = InnoDB;

      CREATE TABLE `cs_cond` (
      `id` BIGINT NOT NULL,
      `repositoryid` VARCHAR(255) NOT NULL,
      `aclinstanceid` BIGINT NULL,
      `expressionid` BIGINT NOT NULL
      ) ENGINE = columnstore;

      CREATE TABLE `cs_acl` (
      `id` BIGINT NOT NULL,
      `repositoryid` VARCHAR(255) NOT NULL,
      `type` SMALLINT NOT NULL DEFAULT 0
      ) ENGINE = columnstore;

      the following query:

      select expr1.id as expr_id, expr1.code as expr_code, expr1.expression, expr1.hash, expr1.repositoryid as expr_repo from (idb_expr expr1 inner join cs_cond cond1 on expr1.id=cond1.expressionid) inner join cs_acl acl1 on cond1.aclinstanceid=acl1.id where acl1.type=1;

      causes an exception:

      ERROR 1815 (HY000): Internal error: InetStreamSocket::readToMagic: Remote is closed

      Is it a bug or there's something wrong in my procedure?
      The output of "columnstoreSupport -a" is atthached

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              SuperC SuperC
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.