3542757 - Wrong results when using descending order and LIMIT clause with allrows_mix - SAP ASE

• Running a query which performs an order by DESC using the LIMIT clause may return incorrect rows.
• Example query:
  select ...
  from t1, t2
  where ....
  order by c1 DESC ROWS LIMIT 20 OFFSET 0

SAP Adaptive Server Enterprise (ASE) 16.0

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