[Resolved] Data not sorted correctly with GROUP_CONCAT

[Nate]

Hi, i'm using

SELECT... GROUP_CONCAT(visitor_tracks.page, '->', visitor_tracks.logged_date_time ORDER BY visitor_tracks.logged_date_time ASC SEPARATOR '\n')

which appears to be the correct syntax according to mysql.com.

I get the results but my dates are not ordered correctly. My dates are stored as DATETIME. Any ideas?

[Nate]

Does no sort correctly

SELECT GROUP_CONCAT( visitor_tracks.request_id ORDER BY visitor_tracks.request_id SEPARATOR '\n') AS page_and_time
FROM visitor_tracks,sessions
WHERE sessions.session_id = visitor_tracks.session_id
GROUP BY visitor_tracks.session_id

Sorts correctly

SELECT GROUP_CONCAT( visitor_tracks.request_id ORDER BY visitor_tracks.request_id SEPARATOR '\n') AS page_and_time
FROM visitor_tracks
WHERE visitor_tracks.session_id = 955
GROUP BY visitor_tracks.session_id

What's the deal?

[Nate]

Well looks like this is a bug. http://bugs.mysql.com/bug.php?id=2695