Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Not a Bug
-
None
-
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.