3210630 - Query plan having store operator for reformatting returns wrong result when default sort order is binaryalt - SAP ASE

• The generated plan is returning wrong result set.
• Observations are:
  
  • Configurable parameters "default character set id" = 190 (utf8)
  • and "default sort order id" = 99 (binaryalt).
• AND IF:
  
  • "optimizer level" = ase_current
  • Or optimizer criterion "cr619756’" is on,
  • Then optimizer generates a query plan having STORE Operator for REFORMATTING
• The reformatted table has a CHAR data type column in a join clause,
  
  • and another column in a search clause which is inside an OR clause,
  • the OR clause has another search clause on a different table. 

SAP Adaptive Server Enterprise (ASE) 16

826609, CR 826609, wrong result, binaryalt, STORE Operator, REFORMATTING, ase_current, cr619756, CHAR, join clause, join OR, OR clause , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error