I have to use cursor to iterate over all the rows in a certain order. But after I implement it with order by, the result is not as expected. I logged the result with ::rowcount, and noticed the order by is not really working.
I have tried to generate row number in the dataset, and then loop through the rows by row number, it will work in this way. But it takes significantly longer time than cursor.
Do you know if using order by with cursor is really supported in HANA?