[MCOL-168] Simple JOIN does not work properly with default configuration from columnstore rpms Created: 2016-06-22  Updated: 2016-10-03  Resolved: 2016-10-03

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

Type: Bug Priority: Critical
Reporter: Justin Swanhart (Inactive) Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

CREATE TABLE `fact` (
`seq` bigint(20) DEFAULT NULL,
`i1` tinyint(4) DEFAULT NULL,
`i2` smallint(6) DEFAULT NULL,
`i4` int(11) DEFAULT NULL,
`i8` bigint(20) DEFAULT NULL,
`i1u` tinyint(3) unsigned DEFAULT NULL,
`i2u` smallint(5) unsigned DEFAULT NULL,
`i4u` int(10) unsigned DEFAULT NULL,
`i8u` bigint(20) unsigned DEFAULT NULL,
`d5` decimal(15,5) DEFAULT NULL,
`f1` float DEFAULT NULL,
`f2` float(2,1) DEFAULT NULL,
`f23` float(23,4) DEFAULT NULL,
`f24` float(24,10) DEFAULT NULL,
`f53` float(53,20) DEFAULT NULL,
`p1` double DEFAULT NULL,
`p2` double(2,1) DEFAULT NULL,
`p23` double(23,4) DEFAULT NULL,
`p24` double(24,10) DEFAULT NULL,
`p53` double(53,20) DEFAULT NULL,
`r1` double DEFAULT NULL,
`d` date DEFAULT NULL,
`dt` datetime DEFAULT NULL,
`c1` char(1) DEFAULT NULL,
`c2` char(255) DEFAULT NULL,
`vc1` varchar(1) DEFAULT NULL,
`vc2` varchar(255) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=latin1 ;

CREATE TABLE `fact_myisam` (
`seq` bigint(20) DEFAULT NULL,
`i1` tinyint(4) DEFAULT NULL,
`i2` smallint(6) DEFAULT NULL,
`i4` int(11) DEFAULT NULL,
`i8` bigint(20) DEFAULT NULL,
`i1u` tinyint(3) unsigned DEFAULT NULL,
`i2u` smallint(5) unsigned DEFAULT NULL,
`i4u` int(10) unsigned DEFAULT NULL,
`i8u` bigint(20) unsigned DEFAULT NULL,
`d5` decimal(15,5) DEFAULT NULL,
`f1` float DEFAULT NULL,
`f2` float(2,1) DEFAULT NULL,
`f23` float(23,4) DEFAULT NULL,
`f24` float(24,10) DEFAULT NULL,
`f53` float(53,20) DEFAULT NULL,
`p1` double DEFAULT NULL,
`p2` double(2,1) DEFAULT NULL,
`p23` double(23,4) DEFAULT NULL,
`p24` double(24,10) DEFAULT NULL,
`p53` double(53,20) DEFAULT NULL,
`r1` double DEFAULT NULL,
`d` date DEFAULT NULL,
`dt` datetime DEFAULT NULL,
`c1` char(1) DEFAULT NULL,
`c2` char(255) DEFAULT NULL,
`vc1` varchar(1) DEFAULT NULL,
`vc2` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

MariaDB [test]> select fact.i1, fact_myisam.i1 from fact join fact_myisam using(seq) where fact.i1 != fact_myisam.i1;
ERROR 1815 (HY000): Internal error: IDB-8001: CrossEngineSupport section in Calpont.xml is not properly configured.

 Comments   
Comment by David Thompson (Inactive) [ 2016-10-03 ]

This is behaving as designed and the error message indicates the reason why. The following knowledge base article covers configuration of cross engine joins:
https://mariadb.com/kb/en/mariadb/configuring-columnstore-cross-engine-joins/

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