CREATE TABLE `q1` (

  `bin1` int(11) DEFAULT NULL,

  `bin2` int(11) DEFAULT NULL,

  `bin3` int(11) DEFAULT NULL,

  `non_zero` int(11) DEFAULT NULL

) ENGINE=Columnstore;

insert into q1 values (0 ,0 ,1 , 10);

insert into q1 values (0 ,0, 23 , 2);

insert into q1 values (0 ,1, 14 , 3);

insert into q1 values (1 ,1 ,7 , 9); 

insert into q1 values (1 ,1 ,7 , 10);

select

    t.bin1,

    if( count(t.bin1) over (  )

        % ( dense_rank() over (order by bin1 asc ) + dense_rank() over (order by bin1 desc ) - 1 ) = 0

        and VARIANCE(t.non_zero) over (  ) = 0

        , 1, 0) as coll1

from q1 t;

ERROR 1815 (HY000): Internal error: Error while fetching from ExeMgr: Row::isNullValue(): got bad column type (32544).  Width=32544