Bug #9495 Mysql server crashes while creating function that has mediumtext as return type
Submitted: 30 Mar 2005 19:15 Modified: 19 Apr 2005 14:54
Reporter: Disha
Status: Duplicate
Category:Server Severity:S2 (Serious)
Version:5.0.3 - Beta OS:Any (ALL)
Assigned to: Bugs System Target Version:

[30 Mar 2005 19:15] Disha 
Description:
When creating a function that has return type as 'Mediumtext' Mysql server crashes and
results in lost connection

How to repeat:
Repro Steps :

1. Create a function FN1, which returns a "Mediumtext" datatype value

CREATE FUNCTION FN1( F1 Mediumtext ) RETURNS Mediumtext 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.
[30 Mar 2005 19:30] Miguel Solorzano 
Verified with 5.0.4 BK.
[19 Apr 2005 14:54] Antony Curtis 
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

This is a duplicate of Bug#9102