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] Shane Bester 
paste into mysql command line client

Attachment: bug37269.sql (application/unknown, text), 8.06 KiB.
[8 Jun 2008 18: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 5:06] Shane Bester 
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.064 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.