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)
• Status: Closed
• 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.