Query Sorting in 5.5

GertV

I've just upgraded to version 5.5 and all my queries in which I sort on a time stamp do not sort correctly anymore.

Example: FIND Tours WHERE Tours.Guides IS UNDEFINED AND Tours.Priority='Confirmed' AND Tours.StartTime<TIME_ADD(CURRENT_TIMESTAMP,240) ORDER BY Tours.TourLocationCode,Tours.StartTime

Tours.StarTime is a timestamp. The query sorts correctly on Tours.TourLocationCode but doesn't sort (or incorrectly sorts) on Tour.StartTime.

The query worked fine in 5.3

Bug?

GertV

Found out that it goes wrong when using the group by function. AwareIM doesn't seem to sort anymore once this option is selected. It also happens when sorting on other fields than timestamps.

GertV

Support, can you confirm this is a bug?

aware_support

It has been like this since day one. Grouping and sorting are incompatible - this is just common sense