[MCOL-1834] DISTINCT Join between latin1 and UTF8 tables fails Created: 2018-10-26  Updated: 2021-02-21  Resolved: 2021-02-21

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.1.6
Fix Version/s: 5.5.1

Type: Bug Priority: Major
Reporter: Andrew Hutchings (Inactive) Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None


 Description   

The following creates an error:

create table tc (a varchar(256) not null) engine=csv;
 
create table td (a bigint, b varchar(256)) default charset=utf8 engine=columnstore;
 
select distinct(td.a), 'B1' AS bloc from td where td.b in (select a from tc where tc.a is not null);

The user error is:

ERROR 1815 (HY000): Internal error: IDB-2035: An internal error occurred.  Check the error log file & contact support.

In logs:

/home/linuxjedi/Programming/Git/mariadb-columnstore-server/mariadb-columnstore-engine/dbcon/joblist/tupleconstantstep.cpp@156: assertion 'j < oidsIn.size()' failed



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-10-26 ]

Changing 'tc' to ColumnStore doesn't fix it.

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