Symptom
IQ 15.2 crashes if a query uses a HASH JOIN contains many LIKE and OR(IN) clauses.
**************************************************
*** Sybase IQ Abort:
*** From: st_server.cxx:1412
*** PID: 22806660
*** Message: caught signal 11, program abort
*** Thread: 334877 (TID: 1302)
**************************************************
...
s_phash::ReHashInternal()+0x4fc()
s_phash::InsertComplete(int)+0x34()
dfjo_Hash::Fetch_T2_IntoHash()+0x564()
dfjo_Hash::ExecWork(int&,unsigned int)+0x1fc()
workAllocator::DoWork(unsigned int)+0x104()
workAllocator::sDoWork(workAllocator*,unsigned int)+0x1c()
Read more...
Environment
- SAP Sybase IQ 15.2
Product
Keywords
SAP IQ, Sybase IQ, ReHashInternal, hash, st_server.cxx:1412, s_phash, join_preference , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.