Symptom
- A query containing many union clauses
- On a table with high number of columns
- Returns error 422 to client and ASE errorlog
Error: 422, Severity: 19, State: 3
Too many nested expressions or logical operators to compile. Try splitting query or limiting ANDs and ORs. - The query can be run successfully under 'compatibility mode'
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE)
- Applies to all ASE versions from 15.0
- 'compatibility mode' configuration setting
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This 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.