3555615 - Query Result returns a wrong result when using CIS.

In the following situation, the query returns fewer results than expected.

• The Query was joining the local table and the proxy table with a WHERE condition by using Component Integration Services (CIS).
• The WHERE condition is using IN and OR clauses on the same column of one of the proxy tables.
  
  (PTA.pub_id in ('11', '12', '70', '91') OR (PTA.pub_id IN ('74') AND PTB.pri_id = '1100'))

Sample Query

SELECT
     LTA.stor_id,
     LTA.au_id
FROM
     Local_tableA   AS LTA,
     Proxy_tableA   AS PTA,
     Proxy_tableB   AS PTB
WHERE
     LTA.au_id = PTA.au_id AND
     PTA.title_id = PTB.title_id AND
     (PTA.pub_id in ('11', '12', '70', '91') OR (PTA.pub_id IN ('74') AND PTB.pri_id = '1100')) AND
     (LTA.start_dt > '2024/09/02 20:08:57' OR LTA.update_dt > '2024/09/02 20:08:57')

• SAP Adaptive Server Enterprise 16.0 (ASE)

ASE 16.0, CIS, Component Integration Services, query, discrepancy, incorrect, 0 rows, CR830243, CR#830243, 830243 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem