Dec 21, 2022 at 11:42 AM

HANA and parametrized query with different results for same parameters

132 Views Last edit Dec 30, 2022 at 05:16 AM 4 rev

Hello everyone,

I have here a custom CDS view. Depending on, how the where clause is created, the result is either 2 or 4 lines

Result with 2 lines (everywhere is select * from ....) :

WHERE "MANDT" = ? AND "INSPECTIONCHARACTERISTIC" = ? AND "MATERIALSAMPLE" = ? AND ( "WORKCENTER" = ? OR "WORKCENTER" = ? )

Result with 4 lines:
WHERE "MANDT" = ? AND ( "MATERIALSAMPLE" = ? AND "WORKCENTER" = ? OR "MATERIALSAMPLE" = ? AND "WORKCENTER" = ? ) AND "INSPECTIONCHARACTERISTIC" = ?

Parameters:
Mandt: 100
INSPECTIONCHARACTERISTIC: 0010
MATERIALSAMPLE: 000900004026
WORKCENTER: LAB_WK1 and LAB_WK2

Funny, that

"MANDT" = '100' AND ( "MATERIALSAMPLE" = '000900004026' AND "WORKCENTER" = 'LAB_WK1' OR MATERIALSAMPLE" = '000900004026' AND "WORKCENTER" = 'LAB_WK2' ) AND "INSPECTIONCHARACTERISTIC" = '0010'

returns only 2 lines.
Bug? or Feature? (Ticket is opened already, but anyway)...