[MCOL-5443] UNKOWN REF Item on inserts Created: 2023-03-07  Updated: 2023-07-01

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 6.4.7- CS only
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: Mario Hubert Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Rocky Linux release 8.6 (Green Obsidian)



 Description   

On insert to a InnoDB table, getting this error/warning UNKOWN REF Item while reading from Columnstore tables.

create table innodb_txn_ids (TransactionID bigint(20) unsigned primary key,
SubscriberID bigint(20) unsigned, ServerID int(11) unsigned) Engine=InnoDB;

insert into innodb_txn_ids (TransactionID,SubscriberID,ServerID)
select t.TransactionID,t2.SubscriberID,t2.ServerID
from transactions.transactionsTracking t
join transactions.transactionlog t2 ON t2.transactionID = t.transactionID
where t.processed IN ("?","S");


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