2949403 - Crash on a_dfe_context::DoMapToPhysicalHandle - SAP IQ

• IQ crashed due a stack trace where we can see the following functions:

=====

a_dfe_context::DoMapToPhysicalHandle
dfv_RowViewContextBase::MapPhysHandle
dfv_RowViewContextBase::GetValuePtr
SAInternalQuery::GetColValue
UIInternalQuery_GetColValue
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::Execute
dfo_EETableUDFLeafCursor::FetchOpus
dfo_Store::Fetch_IntoStore
dfo_Store::SourcePreFetch
dfo::SourcePreFetch
...
...

======

• Crash happens when inserting data and the schema of the result set is different than expected.
• For example, we have this procedure and this temporary table:

=====

CREATE PROCEDURE pjavap(IN Environment VARCHAR(50),IN SQL VARCHAR(4096))
RESULT (
a int,
b int,
c int,
d int
)
EXTERNAL NAME 'Main.xxxxxxxx(xxxxxx/sql/ResultSet;)V'
LANGUAGE JAVA
GO

create table #test
(
a int,
b int,
c int null,
d int
)

=====

• If an insert into the temporary table, the crash occurs:

=====

Insert into #test (a,b,d)
Select a,b,d
From pjavap ('SSSSSSS','select a,b,d from mss_tb')

=====

• If a select statement is executed:

====

Select a,b,d
From pjavap ('SSSSSSS','select a,b,d from mss_test')

====

• An error is returned,  instead of crashing IQ:

SQL Anywhere Error -866: pjavap returned a result set with a different schema than expected.

 SAP IQ 16.0 

insert different schema result set expected crash a_dfe_context::DoMapToPhysicalHandle dfv_RowViewContextBase::MapPhysHandle dfv_RowViewContextBase::GetValuePtr SAInternalQuery::GetColValue UIInternalQuery_GetColValue st_SAIQInterfaceInfo::callFunctionk  822289 CR  822289 CR822289 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed