Bug #34722 ifnull statement crashed mysql
Submitted: 21 Feb 2008 11:57 Modified: 21 Mar 2008 13:55
Reporter: asdfdasf asdfdsf Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Errors Severity:S1 (Critical)
Version:5.0 OS:Microsoft Windows
Assigned to: CPU Architecture:Any
Tags: ifnull mysqld-nt.exe join

[21 Feb 2008 11:57] asdfdasf asdfdsf
Description:
The server crashed when I use the ifnull statement. strangely it only happens when I use it in compination with a join and with a order by:

SELECT pd.permitId, ifNull(PD.coSigner1,0) as coSigner1
from tblPermit as P inner join tblPermitDetails as pd on p.permitId = d.permitId
INNER JOIN tblRisk AS PR ON P.RiskId = PR.RiskId 
ORDER BY PD.permitId DESC

In the query browser it works fine but via an intranet application or the mysql in the command prompt it crashes stating: mysqld-nt.exe has encountered a problem and needs to close.  We are sorry for the inconvenience.

How to repeat:
>MYSQL -uroot -pMyPassword

SELECT pd.permitId, ifNull(PD.coSigner1,0) as coSigner1
from tblPermit as P inner join tblPermitDetails as pd on p.permitId = d.permitId
INNER JOIN tblRisk AS PR ON P.RiskId = PR.RiskId 
ORDER BY PD.permitId DESC;
[21 Feb 2008 12:05] MySQL Verification Team
Thank you for the bug report. Could you please specify the exactly release
server version and test with the latest one (if you have not tried) otherwise
please provide the complete test case: my.ini file, create table statement,
insert data statements. Thanks in advance.
[21 Feb 2008 12:50] asdfdasf asdfdsf
I think this only happens when using a the isnull on a BIT value
[21 Feb 2008 13:55] MySQL Verification Team
Thank you for the feedback, but I still need the complete test case. Thanks
in advance.
[22 Mar 2008 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".