- 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 ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.