2393516 - Query with GROUP BY could fire data conversion error or stack trace in hs_csortexception::hs_csortexception - SAP IQ

Query with GROUP BY could fire

• a data conversion error on version prior to IQ16 SP08 PL38 while no data conversion is required

Data exception - data type conversion is not possible: varchar( 20, 0) to smallint( 5, 0)
using local: SIGNED varchar to UNSIGNED smallint
Exception Thrown from oslib/hos_dfe.cxx:13768, Err# 0, tid 826 origtid 826
O/S Err#: 0, ErrID: 546 (hos_dtexception); SQLCode: -1009145, SQLState: 'QFA2E', Severity: 14
Data type conversion is not possible. varchar( 20, 0) to smallint( 5, 0).-- (oslib/hos_dfe.cxx 13768)

• or a non-fatal stack trace in hs_csortexception::hs_csortexception on IQ16 SP11 PL04.

hs_csortexception::hs_csortexception
hs_csortRetriever::InitNextRetrieverRange
s_keyRangeWorkAllocator::AssignNextWork
df_CombinerFetchContext::PrepareForNextWorkUnit
hc_dmfrun::InitNextWorkUnit
hc_dmfrun::InitNextWorkUnit
hc_dmfrun::ExecWork
workAllocator::DoWork
hos_thread::Main

SAP IQ 16

CR 792702 ; CR# 792702 ; 792702 ; hs_csortexception::hs_csortexception ; hs_csortexception ;
hs_csortRetriever::InitNextRetrieverRange ; hs_csortRetriever ; InitNextRetrieverRange
s_keyRangeWorkAllocator::AssignNextWork ; s_keyRangeWorkAllocator ; AssignNextWork ;
df_CombinerFetchContext::PrepareForNextWorkUnit ; df_CombinerFetchContext ; PrepareForNextWorkUnit , KBA , BC-SYB-IQ , Sybase IQ , Problem