Bug #9537 Mysql server crashes while creating a function that has longtext as return type

• Submitted: 31 Mar 2005 20:32
• Modified: 29 Apr 2005 14:09
• Reporter: Disha
• Status: Closed
• Category: Server
• Severity: S2 (Serious)
• Version: 5.0.3-Beta
• OS: Microsoft Windows (Windows Server 2003)
• Assigned to: Bugs System

[31 Mar 2005 20:32] Disha

Description:
When creating a function that has return type as 'lontext' Mysql server crashes and
results in lost connection

How to repeat:
Repro Steps :

1. Create a function FN1, which accepts a parameter f1 of datatype "longtext", and
returns a "longtext" datatype.

CREATE FUNCTION FN1( F1 longtext ) RETURNS longtext LANGUAGE SQL DETERMINISTIC SQL
SECURITY DEFINER COMMENT 'This is simple'
		Begin
			SET @V1 = 'HELLO';
			set F1 = CONCAT( @V1, F1 );
			RETURN F1;
		End//

2. Observed that the create function fails with a lost connection to the MySQL server
"ERROR 2013 (HY000): Lost connection to MySQL server during query"

Expected Results : The function should be created without any errors or warnings

Actual Results : Mysql server crashes during function creation and results in lost
connection.

[29 Apr 2005 14:09] Per-Erik Martin

No longer repeatable.