2000198 - IQ server returns an internal error "vplib/vp_Projections.cxx:1105".

1. IQ server returns an internal error "vplib/vp_Projections.cxx:1105" against a select distinct statement.

select distinct "COL001" from "TAB001"
 
There is approximatly 1,300,000 rows of data in that column.
The query works when there is no HG index on that column as soon as they create a HG index the stacktrace is produced.
When setting the IQ option aggregation_preference = 3 then the query works.

2. Error messages

********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at vplib/vp_Projections.cxx:1105 on thread 1438242560 (TID 10)
**

pcstkwalk(..............
ucstkgentrace(..............
StackTraceForThisThread(..............
df_Exception::df_Exception(..............
df_Exception::ThrowException_0(..............
vp_OrderedProjection::Prepare(..............
vp_Cursor::PrepareProjection(..............
dfo_VerticalLeafCursor::PrepareProjection(..............
dfo_VerticalLeafCursor::PrepareChildrenAndProjection(..............
dfo_VerticalLeafCursor::PrepareOpus(..............
dfo::PrepareChildren(..............
dfo_Cursor::PrepareOpus(..............
dfo::PrepareChildren(..............
dfo::PrepareOpus(..............

• SAP SYBASE IQ 16.0 SP03

• vplib/vp_Projections, vp_Projections, vp_OrderedProjection::Prepare, vp_OrderedProjection, select distinct, 759084