Bug #9537 Mysql server crashes while creating a function that has longtext as return type
Submitted: 31 Mar 2005 18:32 Modified: 29 Apr 2005 12:09
Reporter: Disha Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.3-Beta OS:Windows (Windows Server 2003)
Assigned to: Per-Erik Martin CPU Architecture:Any

[31 Mar 2005 18: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 12:09] Per-Erik Martin 
No longer repeatable.