2235023 - ORDER BY DESC could return incorrect order -- SAP IQ

• ORDER BY DESC could incorrectly order the result sets in either of the following situations:
• SQL could be sufficiently complex but with no join, with no analytical function and with just an ORDER BY DESC.
• SQLs with analytical ranking and aggregate functions involving OVER PARTITION ORDER BY could return wrong ranking, such as:
• RANK OVER PARTITION BY ORDER BY
• DENSE_RANK OVER PARTITION BY ORDER BY 
• NTILE OVER PARTITION BY ORDER BY
• ROW_NUMBER OVER PARTITION BY ORDER BY
• PERCENT_RANK OVER PARTITION BY ORDER BY
• WEIGHTED_AVG OVER PARTITION BY ORDER BY
• LAG OVER PARTITION BY ORDER BY
• LEAD OVER PARTITION BY ORDER BY
• The issue is more likely to occur when there are:
• PARTITION BY X ORDER BY Y, Z DESC
• PARTITION BY X, Y ORDER BY Z DESC
• at least one column is ordered by DESCENDING in the ORDER BY clause
• a join between 1 or more tables, one of the join column is in the PARTITION BY clause 

• SAP IQ 15.x
• SAP IQ 16

KBA , BC-SYB-IQ , Sybase IQ , Problem