Bug #9495 Mysql server crashes while creating function that has mediumtext as return type
Submitted: 30 Mar 2005 17:15 Modified: 19 Apr 2005 12:54
Reporter: Disha Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.3 - Beta OS:Any (ALL)
Assigned to: Assigned Account CPU Architecture:Any

[30 Mar 2005 17: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 17:30] MySQL Verification Team 
Verified with 5.0.4 BK.
[19 Apr 2005 12: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