MySQL Bugs: #10004: floating point query crashes server

Bug #10004	floating point query crashes server
Submitted:	19 Apr 2005 16:21	Modified:	6 May 2005 22:11
Reporter:	Tom Cunningham	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.3-beta-nt/5.0.4	OS:	Windows (Win XP)
Assigned to:	Alexey Botchkov	CPU Architecture:	Any

Description:
The following query suddenly crashes my server (originally it was another query, I simplified it to use a table that exists on all servers).

select 0.190287977636363637 + 0.040372670 * help_category_id - 
help_category_id from mysql.help_topic; 

Most other queries run fine on my server.

This query runs fine on v4.1.

version details: 
+---------------------------------+-------------------------------------------------------------------+ 
| Variable_name | 
Value | 
+---------------------------------+-------------------------------------------------------------------+ 
| version | 
5.0.3-beta-nt | 
| version_comment | Official MySQL 
binary | 
| version_compile_machine | 
ia32 | 
| version_compile_os | 
Win32 | 
+---------------------------------+-------------------------------------------------------------------+ 

How to repeat:
see above

bk commit - 5.0 tree (holyfoot:1.1927) BUG#10004

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html