ADDDATE in a view - db crashes on ORDER BY

[Jonny Becker]

Hi,

DB : MySQL 5.0.3

I want to create a view with a ADDDATE-function in my SELECT.

CREATE VIEW view_flight AS
select ADDDATE(sf.date, sp.period) AS arrdate
from sflight sf, spfli sp
WHERE ...
order by sf.carrid, sf.connid;

The SELECT itself works fine. Also the view without the ORDER BY. But when the ORDER BY-clause is in the view, the db-crashes.

So my guess is that the ADDDATE-function in combination with the ORDER BY-clause causes this crash.

Any ideas what causes it? Is there a workaround for this?

Thanks
Jonny