Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.1.2
-
None
-
2018-06, 2018-07
Description
create database ct;
use ct;
create table test_inno (astr VARCHAR(50))ENGINE = INNODB ;
create table test_mcs (astr VARCHAR(50))ENGINE = COLUMNSTORE ;
INSERT INTO test_inno (astr) value('test');
INSERT INTO test_mcs (astr) value('test');
innodb:
SELECT astr FROM test_inno WHERE CASE WHEN 1 = 1 THEN (astr = 'test' OR astr = 'unknown') END;
------
astr |
------
test |
------
1 row in set (0.01 sec)
columnstore:
SELECT astr FROM test_mcs WHERE CASE WHEN 1 = 1 THEN (astr = 'test' OR astr = 'unknown') END;
ERROR 1178 (42000): The storage engine for the table doesn't support Unknown item type
Attachments
Issue Links
- is part of
-
MCOL-1234 Nested CASE filters not processed
- Closed