
-- MCOL-1155
-- I can work around with colum1 is not null and column2 is null... 
-- but should it work with NOT (column1 <=> column2)? Here's an example.

DROP TABLE if exists t1;
DROP TABLE if exists t2;

CREATE TABLE t1 ( c1 int not null, c2 float, c3 char(10)) engine=columnstore;
insert into t1 values(1,1.0, 'one'), (2,2.0, 'two'), (3, 3.1, 'three');

CREATE TABLE t2 ( c1 int not null, c2 float, c3 char(10)) engine=innodb;
insert into t2 values(1,1.0, 'one'), (2,2.0, 'two'), (3, 3.1, 'three');

select c1, c2+5 from t1  where (case when c1 > 2  then 1 else null end);
select c1, c2+5 from t1  where  c1 > 2  is not null;
select c1, c2+5, (c1 > 1) is null from t1 ; 

select c1, c2+5 from t2  where (case when c1 > 2  then 1 else null end);
select c1, c2+5 from t2  where  c1 > 2  is not null;
