Skip to Content
0
Former Member
May 12, 2016 at 02:32 PM

Problem at SELECT ... IN .... (fatal error: Execution flow must not reach here)

1210 Views

Hello guys,

I'm facing a serious issue after a HANA upgrade to SPSS11.

while doing non regression tests, i found a regression on a webi report and the SQL code is the following :

SELECT

"LIFNR",

"MANDT",

"NAME1",

sum("CA_facturé") AS "CA_facturé"

FROM "_SYS_BIC"."TEST" WHERE "_SYS_BIC"."TEST"."LIFNR" IN ('VAL1','VAL2', 'VAL3', 'VAL4', 'VAL5', 'VAL6', 'VAL7', 'VAL8', 'VAL9', 'VAL10', 'VAL11', 'VAL12', 'VAL13', 'VAL14', 'VAL15')

GROUP BY

"LIFNR",

"MANDT",

"NAME1"

when executing this script i obtain this error in HANA :

SAP DBTech JDBC: [3]: fatal error: [3] fatal error: Execution flow must not reach here. See error trace for details

But strangely when i put less than 15 values in the "IN" operator it works.

Do you have any feedbacks on this kind of issues ?

Thank you so much.