Bug #4191 MySQL crashes on subquery in stored procedure
Submitted: 17 Jun 2004 17:24 Modified: 22 Jul 2004 12:18
Reporter: Arnold Daniels Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[17 Jun 2004 17:24] Arnold Daniels
Description:
On a certain query using a subquery in a stored procedure, mysqld-nt crashes. I've used the same procedure in a Linux envirement without problems.
I don't know what the problem is, it might also be data related.

How to repeat:
Please send me an e-mail to receive the full code, plus dump of the related tables + data. I don't wan't to make this all public.
[17 Jun 2004 17:35] Arnold Daniels
It seems to be system related. It does work on Linux.
[17 Jun 2004 17:43] Arnold Daniels
It migth be related to bug 3971
[20 Jun 2004 6:23] MySQL Verification Team
You can download the zip file with the test case at:

ftp://support.mysql.com/pub/mysql/download

and please let me know here.

thanks.
[22 Jun 2004 12:18] Arnold Daniels
I've added the sql dump of my database (created by PhpMyAdmin) + some stored procedures (created in VS.NET). These files are private.

Please run 'telecom_subscription_get_price' on a windows server. You will see it crashes.

P.S. the ftp address suppositly leading to a testcase is an empty folder.
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".