[#MCOL-2109] There is a problem when adding OR condition

[my environment]
Red Hat Enterprise Linux Server Version 6.9
MariaDB Columnstore ver 1.1.2
64GB of memory

Operational data identity issues occur.
Development / testing / operation is possible. If there is no abnormality, please check the case.

create table test (

    trn_sumry1 varchar(80) default null

) engine=columnstore default charset=utf8;

insert into test

select '대체' union all

select '운영';

This is working fine.

 -- 1 row(s) returned

SELECT * FROM test WHERE trn_sumry1 = '대체';

-- 1 row(s) returned

SELECT * FROM test WHERE trn_sumry1 = '운영';

-- 0 row(s) returned

SELECT * FROM test WHERE trn_sumry1 = '한글';

-- 0 row(s) returned

SELECT * FROM test WHERE trn_sumry1 = '테스트';

-- 0 row(s) returned

SELECT * FROM test WHERE trn_sumry1 IN ('한글', '테스트');

wrong results as below;

 -- 2 row(s) returned

SELECT * FROM test WHERE trn_sumry1 = '한글' OR trn_sumry1 = '테스트';

trun_sumr1

-----------

대체

운영

-----------

There is no problem when performing a single condition, but there is a problem when adding OR condition.

I installed VMware + ubuntu 16.04 LTS + columnstore-1.1.2-1 on my local PC for further testing
There was no problem when I performed the same test with the default setting of columnstore.xml.

MariaDB ColumnStore 1.1.3 GA Release Notes
• ~~MCOL-1029~~ - Logic issue breaking multiple where conditions

I wonder if the same symptoms as we have on ~~MCOL-1029~~
I wonder if the upgrade of 1.1.3 or later can solve this problem.

Thank you.

[MCOL-2109] There is a problem when adding OR condition Created: 2019-01-25 Updated: 2023-03-06 Resolved: 2023-03-06
Status:	Closed
Project:	MariaDB ColumnStore
Component/s:	N/A
Affects Version/s:	1.1.2
Fix Version/s:	Icebox

[MCOL-2109] There is a problem when adding OR condition Created: 2019-01-25 Updated: 2023-03-06 Resolved: 2023-03-06

*This is working fine. *

wrong results as below;

This is working fine.