Each order key by can be specified with ascending or descending order.
Recently, I found that ORDER BY with the first descending order key causes wrong result.
If second key is a descending order, it works well. Other cases work correctly.
But, if the first sort key is a descending order, it causes wrong row number and shows wrong range part as follows:
According to my investigation, it seems to be related to offset problem of RowFile or index problem. The final result includes duplicated rows and the final row was wrong as follows: