[MCOL-3244] cross-engine join: failed conversion using boost::any_cast Created: 2019-04-10  Updated: 2023-03-06  Resolved: 2023-03-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.2.3
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: antoine Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None
Environment:

debian9


Issue Links:
Relates
relates to MCOL-3469 cross-engine join + is null filter on... Closed

 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



 Comments   
Comment by Todd Stoffel (Inactive) [ 2023-03-06 ]

This ticket was created prior to convergence with the server and may be obsolete. If you find this issue still exists in a modern version, please open a new ticket.

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