3399905 - A query with many union clauses on a table with many columns reports error 422 - SAP ASE

• 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'

• SAP Adaptive Server Enterprise (ASE)
  • Applies to all ASE versions from 15.0
  • 'compatibility mode' configuration setting

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem