Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.2.3
-
None
-
debian9
Description
error with innodb-columnstore cross engine join with a IS NULL / IS NOT NULL filter on an innodb time-column
select from (innodb)
left join (mcs)
where (innodb time column is null)
error was not present in 1.1.7
drop table if exists `idb`; |
CREATE TABLE `idb` ( |
`ID` int unsigned NOT NULL, |
`T` time DEFAULT NULL, |
PRIMARY KEY (`ID`) |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
drop table if exists `mcs`; |
CREATE TABLE `mcs` ( |
`ID` int unsigned NOT NULL, |
`Y` smallint unsigned DEFAULT NULL |
) ENGINE=Columnstore DEFAULT CHARSET=utf8; |
|
SELECT |
count(*) |
FROM `idb` t1 |
LEFT JOIN `mcs` t2 ON t1.`ID` = t2.`ID` |
WHERE (t1.`T` IS NOT NULL); |
=> Error Code: 1815. Internal error: boost::bad_any_cast: failed conversion using boost::any_cast
the error comes specifically from the where on the time column. If X is made INT then the query works
the error comes from the IS NULL / is NOT NULL filter. a where X>='12:34:56' works
Attachments
Issue Links
- relates to
-
MCOL-3469 cross-engine join + is null filter on time column
- Closed