3782916 - SAP IQ server aborts repeatedly during running a specific "select" query statement using LF index

• SAP IQ server aborts during running following query statement.(an LF index is created on tab01.col01)

select
    top 1000 *
from
    (
    select
        "col01",
        "count"() as "err_cnt_"
    from
        (
        select
            *
        from
            (
            select
                *,
                "rowid"("a") as "rn_"
            from
                "owner01"."tab01" as "a"
            where
                1 = 1
                and "col01" <> ''
                and "col01" is not null
                and "col01" not in('24')
            ) as "a"
    where
        1 = 1
        and (case when "length"("trim"("col01")) = 2
        and "col01" like '[0-9][0-9]'
        and "substr"("trim"("col01"),1,2) between '00' and '23' then 1 else 0 end) = 0
    ) as "aa"
group by
"aa"."col01"
) as "z"

• stacktrace from .iqmsg

pcstkwalk
ucstkgentrace
DumpAllThreads
hos_ABORT
SigHndlr+0x6c
hs_lcGroup::Fetch
s_fetchGroup::_FetchNextGroup
s_fetchGroup::Fetch
s_fetchGroup::Fetch
vp_Cursor::Fetch
dfo_VerticalLeafCursor::FetchOpus
dfo_Root::FetchOpus
dfo_Root::FetchOpus
st_cursorIQtoSA::FetchRows
st_cursorIQtoSA::Execute
df_OpenCursor::Execute
st_command::DoCmdThroughResourceGate
st_iqdml::OpenCursor
UIQDML_OpenCursor+0x4c
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholddml::OpenCursor
df_OmniRowScan::Restart
dfo_Scan::DoFetch
dfo_Scan::DoFirstFetch
dfo_Base::Fetch
dfo_Root::DoFetch
dfo_Root::DoFirstFetch
dfo_Base::Fetch
dfo_Root::DoFetchRelative
dfo_Root::FetchRelative
DB_Search_fetch
do_move_cursor
move_cursor
dbi_fetch
do_full_fetch
do_cursor_execute
db__execute_any_imm
do_request
RequestProcedure::call
Worker::spawn
EngStream::handle_ind
EngStream::execute
RQConnItem::do_request
RQBaseItem::do_work
RequestQueue::worker_body
request_task
run_task_body+0x48
UnixTask::pre_body
<unknown>

• AIX
• SAP IQ 16.1 SP04.10

hs_lcGroup::Fetch, grouped leaf, LF index, iq crash, server termination, stack trace, 16.1 sp04, 16.1 sp05 pl10, non-deterministic result, SQLCODE 122, AIX 7.1, group by, like pattern, substr trim length , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem