Bug#383826: mysql Time-Sorting is not working

[Michael Sordje]

Package: mysql-server-5.0 Version: 5.0.22-4   Problem occurs here:   I have a table: Fields: id (INT), starttime (DATETIME), runtime (INT)   Works: SELECT id FROM table ORDER BY (starttime+INTERVAL runtime SECOND) ASC   Does not work: SELECT id, (starttime+INTERVAL runtime SECOND) AS zeit FROM table ORDER BY (starttime+INTERVAL runtime SECOND) ASC   Works: SELECT id, (starttime+INTERVAL runtime SECOND) AS zeit FROM table ORDER BY zeit ASC   Here is definitvly a bug with DATETIME and ORDERS   Greets