Bug #22702 IF Statement didnt work by unsigned zerofill
Submitted: 26 Sep 2006 15:06 Modified: 26 Oct 2006 18:04
Reporter: Juergen Heinemann Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.24 OS:Linux (Linux SuSE-9.3)
Assigned to: CPU Architecture:Any

[26 Sep 2006 15:06] Juergen Heinemann 
Description:
`image` smallint(9) unsigned zerofill NOT NULL default '000000000'
On MySQL  4.1* this SQL Statement Works
IF( ABS(`image`) > 0, `image`, '' ) AS `image`
on mysql 5.0.24 it returns no value when if = false and the default value isn't set
IF( ABS(`image`) > 0, `image`, '000000000' ) AS `pic`

How to repeat:
unknown
[26 Sep 2006 18:04] Valeriy Kravchuk 
Thank you for a problem report. Please, provide a complete test case, with CREATE TABLE, INSERT(s) and complete SELECT statement that demonstrates the behaviour described.
[26 Oct 2006 23: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".