Bug #119414 0.0 is treated differently

• Submitted: 17 Nov 23:55
• Reporter: wenwen wen
• Status: Open
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: mysql Ver 9.4.
• OS: MacOS
• CPU Architecture: Any

[17 Nov 23:55] wenwen wen

Description:
select '0' union select -5.0 + 5.0 gives only ’0’ but select '0' union
select 0.0 gives ’0’ and ’0.0’.

How to repeat:
you just union '0' with any operation that could result in 0.0.