Bug #10599 Numeric function 'abs' make server crash
Submitted: 12 May 2005 14:22 Modified: 19 May 2005 14:11
Reporter: Disha Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.5-beta-nt OS:Microsoft Windows (Windows xp)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[12 May 2005 14:22] Disha
Description:
Repetedly call abs function make server crash down.

How to repeat:
Repro Steps:
1. execute the following command.
	delimiter //
2. execute the following command 2/3 times
	select abs(10/0)//

Expected Result: Null value or error message like division by '0' 

Actual Result: ERROR 2013 (HY000): Lost connection to MySQL server during query
[12 May 2005 16:16] Miguel Solorzano
On Linux:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 5.0.6-beta-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> delimiter //
mysql> select abs(10/0)//
ERROR 2013 (HY000): Lost connection to MySQL server during query
[12 May 2005 19:14] Omer Barnir
Setting to P2 since this is a crashing bug
[13 May 2005 14:00] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/24864
[19 May 2005 8:59] Ramil Kalimullin
Fixed in 5.0.7
[19 May 2005 14:11] Paul Dubois
Noted in 5.0.6 changelog.