- Old stored procedure with queries that have outer joins fail with Error 11055 on ASE 16.0:
Error (11055) Severity (16) State (2) Server (xxxxxx) Procedure (xxxxxxx) Query contains an illegal outer-join request
- The same stored procedures run without errors on ASE 15.0.3.
- This is a simplified example of a failing query:
from unused_person_id p2
where p1.person_id *= p2.person_id)
from person_test p1,
where p1.ssn *= dp.ssn
SAP Adaptive Server Enterprise (ASE)
CR125533, CR#125533, 125533, CR#194304, CR194304, 194304, TF, trace, flag, 298, correlated, outer, join, subquery, 11013, 301 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.