Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#260 IFNULL garbles numeric fields values

3.4.0
closed-works-for-me
Jakub Vrána
MySQL (65)
5
2012-12-16
2012-07-07
Michele Salvador
No

1) go to Adminer demo http://adminer.sourceforge.net/adminer.php?username=

2) in 'SQL command' paste the query:
CREATE VIEW `duration_with_ifnull` AS SELECT duration as duration, IFNULL(`duration`,'') AS `IFNULL(duration)` FROM `songs`;

3) Go to database and select view 'duration_with_ifnull'

4) Notice how values in columns 'duration' and 'IFNULL(duration)' are different
'3' is added before every number and ':' is replaced by 'a'

Cheers

Discussion

  • Jakub Vrána
    Jakub Vrána
    2012-12-16

    Couldn't reproduce.

     
  • Jakub Vrána
    Jakub Vrána
    2012-12-16

    • status: open --> closed-works-for-me