MySQL Bugs: #16609: Sorting by last action date is inaccurate

Bug #16609	Sorting by last action date is inaccurate
Submitted:	18 Jan 2006 15:50	Modified:	19 Jan 2006 9:38
Reporter:	Dan Karran	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	Eventum	Severity:	S2 (Serious)
Version:	1.7.0	OS:
Assigned to:		CPU Architecture:	Any

Description:
When sorting issues by Last Action Date, the order of issues is not clear. At first it seems as though the latest updated issues (whether it be creation, adding notes, etc) are those listed at the top. However, there are new issues which don't rise to the top of the list. 

Inverting the order of the list should bring the oldest to the top, but in fact shows more issues that have been modified very recently.

When showing all issues on one page, they appear to go from 0 days, 0 hours at the start of the list, to older issues in the middle of the list, and then slowly get newer again until they reach different issues that are from 0 days, 0 hours at the bottom of the list.

(The iss_updated_date appears to be present and correct in all issues in the eventum_issues table.)

How to repeat:
List all issues, click to sort column by Last Action Date. New issues should be at top of list if ascending (or bottom of list if descending), but if you scroll down the list you will see inconsistency in the ordering.

Hi Dan,

Please see: http://lists.mysql.com/eventum-users/2684 for a post that covers this bug (and a fix). It will be included in our next release. I am closing this bug, but please re-open it if that fix does not work for you.

Thanks, that fix worked a treat! Sorry, should have thought to check the mailing list for the answer.