Hi,

Can you please send us the schema for the item table?

Issue confirmed. Many thanks.

The following simple query will also crash the columnstore server:
select i_product_name
from item
where i_manufact_id > 742 and
(select count as item_cnt from item where ((i_category = 'Women' ))) > 0
;

Comment for QA:
This problem is caused by handling a sub-query marked as an CACHED_ITEM by MariaDB server. The columnstore cannot assume that this is cached and it needed to parse the subquery any way. Note that a single subquery in the WHERE clause is not marked as a cached item. The code change also touched handling of constant expressions "(TRUE or FALSE)", "1=0" or "1=1". I tested the fix using the original supplied query as well as the following:
CREATE TABLE cs_item (
`i_product_name` char(50) DEFAULT NULL,
`i_category` char(50) DEFAULT NULL,
`i_manufact_id` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=latin1 ;

select i_product_name from cs_item
where i_manufact_id > 742 and (select count as item_cnt from cs_item where ((i_category = 'Women' ))) > 0 ;

select i_product_name from cs_item
where i_manufact_id > 742 and (select count as item_cnt from cs_item where ((i_category = 'Women' ))) > 0 and (1=0);

select i_product_name from cs_item
where i_manufact_id > 742 and (select count as item_cnt from cs_item where ((i_category = 'Women' ))) > 0 and (1=1);

select i_product_name from cs_item where i_manufact_id > 742 and i_category = 'Women' ;
select i_product_name from cs_item where i_manufact_id > 742 and i_category = 'Women' AND (TRUE OR FALSE);
select i_product_name from cs_item where i_manufact_id > 742 and i_category = 'Women' AND ( 1 = 0);
select i_product_name from cs_item where i_manufact_id > 742 and i_category = 'Women' AND ( 1 = 1);
select i_product_name from cs_item where i_manufact_id > 742 and i_category = 'Women' AND ( 1 > 5/7);
select i_product_name from cs_item where i_manufact_id > 742 and i_category = 'Women' AND ( 1 > 7/5);
select i_product_name from cs_item where i_manufact_id > 742 and i_category = 'Women' AND ( i_manufact_id > 300 OR i_manufact_id <= 300);
select i_product_name from cs_item where i_manufact_id > 742 and i_category = 'Women' AND (TRUE);
select i_product_name from cs_item where i_manufact_id > 742 and i_category = 'Women' AND (FALSE);

The fix is to to not skip the walking of an item marked as CACHED_ITEM. A subquery is not really cached and needed to be traversed before it can be converted into column store tree.

Build verified: 1.1.7-1

Verified test cases in the ticket.