Bug #37269 parser crash when creating stored procedure

• Submitted: 8 Jun 2008 16:01
• Modified: 24 Jul 2008 19:47
• Reporter: Shane Bester
• Status: Closed
• Category: Server: Parser
• Severity: S1 (Critical)
• Version: 5.0.64, 5.1.26
• OS: Any
• Assigned to: Marc Alff
• Target Version: 5.0+
• Triage: D1 (Critical)

[8 Jun 2008 16: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 16:01] Shane Bester

paste into mysql command line client

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

[8 Jun 2008 20:42] Shane Bester

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 7:06] Shane Bester

a more intense testcase that crashes

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

[9 Jun 2008 17:02] Marc Alff

See related
Bug#35577 CREATE PROCEDURE causes either crash or syntax error depending on build

[23 Jul 2008 2: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 17: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 17: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 18:59] Marc Alff

Pushed into 6.0.7-alpha with bug#35577

[24 Jul 2008 19:47] Paul DuBois

Noted in 6.0.7 changelog.