3805235 - Incorrect result when use limit/offset and order by with Union - SAP ASE

The query statement which having the order by and limit/offset clause with the union may return the incorrect result

For example:

select c1,c2 from t1
union
(select d1,d2 from t2)
order by c1,c2 rows limit 3 offset 2

SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL07 or above

823830, CR823830, CR 823830 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem