Symptom
- SAP IQ Crash
- The SQL looks like the following
select .......
from
(select 0 as "COL1", 20 as "COL2", '0 - 20 lat' as "COL3" union all
select 21, 30, '21 - 30' union all
select 31, 40, '31 - 40' union all
select 41, 50, '41 - 50' union all
select 51, 60, '51 - 60' union all
select 61, 70, '61 - 70' union all
select 71, 80, '71 - 80' union all
select 81, 125) as "VIEW1"
join "TABLE1" as "NEW_TABLE" on ("VIEW1"."COL1" <= "TABLE2"."COL2" and "VIEW1"."COL1" >= "TABLE3"."COL3")
Excerpt of stack trace
__do_global_dtors_aux_fini_array_entry
Connection::fire_yield_actions
Worker::yield_to_forbidding
Context_switch
df_RecSinkSortOStream::StartAddRec
df_RecSinkSortOStream::AppendFromMatInput
df_RecSinkSortOStream::~df_RecSinkSortOStream
df_RecSinkSortOStream::~df_RecSinkSortOStream
df_RowSinkRecOStream::~df_RowSinkRecOStream
df_RowSinkSortOStream::~df_RowSinkSortOStream
dfo_SortReplacement::PopulateFully
dfo_SortReplacement::DoFirstFetch
dfo_Base::Fetch(a_cursor_orientation)
dfo_PacketBuffer::DoFetch(a_cursor_orientation)
dfo_Base::Fetch(a_cursor_orientation)
df_Packet::NextPacket(a_cursor_orientation)
Read more...
Environment
- SAP IQ 16.1 SP04
- SAP IQ 16.0 SP11
Product
Keywords
KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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.
SAP Knowledge Base Article - Preview