[MCOL-5507] Unable to join ColumnStore table w/ InnoDb Created: 2023-05-11  Updated: 2023-07-03  Resolved: 2023-07-02

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

Type: Bug Priority: Blocker
Reporter: Evan Howlett Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

OS: 18.04.6 LTS (Bionic Beaver)
CPU: Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Single node instance

Columnstore.xml:

<CrossEngineSupport>
<Host>localhost</Host>
<Port>3306</Port>
<User>correct_user</User>
<Password>correct_password</Password>
<TLSCA/>
<TLSClientCert/>
<TLSClientKey/>
</CrossEngineSupport>


 Description   

I am getting this error

May 11 12:40:58 localhost joblist[4346]: 58.325928 |1295|0|0| C 05 CAL0000: CrossEngineStep::execute() caught Throw location unknown (consider using BOOST_THROW_EXCEPTION)#012Dynamic exception type: boost::exception_detail::clone_impl<boost::exception_detail::error_info_injector<boost::bad_any_cast> >#012std::exception::what: boost::bad_any_cast: failed conversion using boost::any_cast

when trying to join these two tables on the "SkuCode" column.

CREATE TABLE `lineItemSalesClosed` (
...
`SkuCode` varchar(32) DEFAULT NULL,
...
) ENGINE=Columnstore DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE `sku` (
`SkuId` varchar(36) NOT NULL,
`SkuCode` varchar(32) NOT NULL,
...
PRIMARY KEY (`SkuCode`),
...
USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

Query:
select *
from
views.lineItemSalesClosed lisc
left join views.sku s on lisc.SkuCode = s.SkuCode

 Comments   
Comment by Evan Howlett [ 2023-07-03 ]

Could it have something to do with upgrading from a version of MySql? What were the steps taken to try to reproduce the issue?

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