Bug #37269 parser crash when creating stored procedure
Submitted: 8 Jun 2008 14:01 Modified: 24 Jul 2008 17:47
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Parser Severity:S1 (Critical)
Version:5.0.64, 5.1.26 OS:Any
Assigned to: Marc ALFF CPU Architecture:Any

[8 Jun 2008 14:01] Shane Bester
Description:
running the create procedure statement with many levels of nested blocks crashes with stack trace:

mysqld.exe!MYSQLparse
mysqld.exe!parse_sql
mysqld.exe!mysql_parse
mysqld.exe!dispatch_command
mysqld.exe!do_command
mysqld.exe!handle_one_connection
mysqld.exe!pthread_start
mysqld.exe!_callthreadstart
mysqld.exe!_threadstart
kernel32.dll!FlsSetValue

I think it might be related to bug #37228

How to repeat:
see uploaded file
[8 Jun 2008 14:01] MySQL Verification Team
paste into mysql command line client

Attachment: bug37269.sql (application/unknown, text), 8.06 KiB.

[8 Jun 2008 18:42] MySQL Verification Team
another testcase causing the same crash. I got syntax errors sometimes, and mostly crashes on -debug build

Attachment: bug37269_testcase2.sql (application/unknown, text), 1.13 KiB.

[9 Jun 2008 5:06] MySQL Verification Team
a more intense testcase that crashes

Attachment: bug37269_testcase3.sql (application/unknown, text), 1.14 KiB.

[9 Jun 2008 15:02] Marc ALFF
See related
Bug#35577 CREATE PROCEDURE causes either crash or syntax error depending on build
[23 Jul 2008 0:27] Paul DuBois
Noted in 5.1.28 changelog.

Freeing of an internal parser stack during parsing of complex stored
programs caused a server crash.

Setting report to Need Doc Info pending push into 5.0.x/6.0.x.
[23 Jul 2008 15:26] Marc ALFF
Pushed into 5.0.68.

Still waiting on 6.0.x merge, change back to NDI after documenting 5.0.68
[23 Jul 2008 15:41] Paul DuBois
Noted in 5.0.68 changelog.

Setting report to Need Doc Info pending push of fix into 6.0.x.
[24 Jul 2008 16:59] Marc ALFF
Pushed into 6.0.7-alpha with bug#35577
[24 Jul 2008 17:47] Paul DuBois
Noted in 6.0.7 changelog.