Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.0.6.1
-
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
- relates to
-
MCOL-356 BLOB data type not supported
- Closed