MaxDB 7.9 ignors sorting?

[former_member201326]

Hi,

one of our developers discovered a change of behaviour in 7.9 which he is not used to (coming from 7.6)

Here is his select.

SELECT land1 prdid FROM /prod/fuba UP TO 1 ROWS

   INTO (lv_land1, ls_fuba-prdid)

   WHERE land1 = iv_land1

      OR land1 = space

      OR land1 = '*'

   ORDER BY land1 DESCENDING.

ENDSELECT.

Hi expects the database to sort countries in descending order. If DE and SPACE are selected the sorting order is ignored. If DE, CH and SPACE is selected, expecting a result of three datasets, the result will be sorted alright.

So, while selecting less than three datasets sorting will not work.

Has anyone else seen this? We are on 7.9.08.24, Linux 64bit.

Thank you

Sven

Message was edited by: Sven Kotting

[birgit_malik]

Hi Sven, it would be great if you could open an OSS message for component BC-DB-SDB. Then we can evaluate this issue using database traces. Regards Birgit Malik

[former_member201326]

Thanks, I have done so. It will take a day or two since our tickets will have to go through an IBM account.

I wanted to Switch this System to our developer account but I am technically not allowed to do that and have not heard (yet) back from our PSA about that.

Regards

Sven Kotting