Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.1.5
-
None
Description
To reproduce:
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
|
removing the variance window function or adding a partition clause to it removes the error.