Bug #10599 Numeric function 'abs' make server crash

• Submitted: 12 May 2005 14:22
• Modified: 19 May 2005 14:11
• Reporter: Disha
• Status: Closed
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.0.5-beta-nt
• OS: 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] MySQL Verification Team

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.