Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.1.2
-
None
-
Red Hat Enterprise Linux Server Version 6.9
mariadb-columnstore-1.1.2-1
Description
[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.