Re: This query crashes mysqld... - Sinisa Milivojevic - com.mysql.lists.bugs

4 messages in com.mysql.lists.bugsRe: This query crashes mysqld...

From	Sent On	Attachments
Matrix	06 Jan 2001 13:14
Sinisa Milivojevic	07 Jan 2001 04:23
Matrix	07 Jan 2001 13:55
Michael Widenius	08 Jan 2001 06:02

Subject:	Re: This query crashes mysqld...
From:	Sinisa Milivojevic (sin...@mysql.com)
Date:	01/07/2001 04:23:36 AM
List:	com.mysql.lists.bugs

Matrix writes:

Hello-

I'm a PHP developer, and I use MySQL now and then, so I don't have a vast knowledge of it. However, from what I understand, mysqld should never crash, but for me it does...

OS: Windows 2000 Query: "SELECT *, DATE_FORMAT(RawDate,'%M %D, %Y') AS Date, DATE_FORMAT(RawDate,'%l:%i') AS Time FROM tablename ORDER BY Date ASC"

Reason: I know why it is crashing -- I have a field called "Date" and "Time" already, and I'm attempting to "recreate" them with the "AS" statements. At the time of this error, I wasn't aware that I even had those fields. If I rename my old fields "DateOLD" and "TimeOLD", that query will work fine. However, this query should return an error, not crash mysqld...

If you need any more information, feel free to email me!

Keep up the great work on MySQL! :)

Hi!

Is MySQL crashing or does it return error.

If it crashes, then we should need more info to take a look at it.

If it returns error message, then it is expected behaviour.

Regards,

Sinisa