Menu

#260 IFNULL garbles numeric fields values

3.4.0
closed-works-for-me
MySQL (74)
5
2012-12-16
2012-07-07
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
     

Log in to post a comment.