MySQL Bugs: #53047: StackOverflow while opening QUAN details for deep nested query (more 8 levels)

Bug #53047	StackOverflow while opening QUAN details for deep nested query (more 8 levels)
Submitted:	22 Apr 2010 8:26
Reporter:	Andrii Nikitin	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Enterprise Monitor: Server	Severity:	S3 (Non-critical)
Version:	2.1, 2.2.0.1693	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
Following Exception shown when clicking on deep nested query in QUAN page in dashboard.

"
An Error Occurred

    * java.lang.reflect.InvocationTargetException sun.reflect.GeneratedMethodAccessor214.invoke(Unknown Source)
"

If email notifications enabled, stacktrace starting with following is sent (see attached file):

java.lang.StackOverflowError
at org.antlr.stringtemplate.StringTemplate.getAttributeRenderer(StringTemplate.java:1033)
at org.antlr.stringtemplate.StringTemplate.getAttributeRenderer(StringTemplate.java:1045)
...

How to repeat:
1. setup query analyzer
2. run following SQL:

set group_concat_max_len = 1024*1024;

select concat(
  group_concat("select 1 from (" separator ""), 
  "select 1", 
  repeat(") a", count(*)), ";") as deep_nested_query 
from (select 1 from mysql.help_topic limit 8) a 
into outfile "/tmp/n8.sql";

source /tmp/n8.sql

select concat(
  group_concat("select 1 from (" separator ""), 
  "select 1", 
  repeat(") a", count(*)), ";") as deep_nested_query 
from (select 1 from mysql.help_topic limit 9) a 
into outfile "/tmp/n9.sql";

source /tmp/n9.sql

3. Open query analyzer, click on later query and observe "An Error Occurred" from Description.

Suggested fix:
avoid error message: show of truncate query in QUAN details

formatter stackoverflow with stacktrace

Attachment: stacktrace.log (application/octet-stream, text), 54.95 KiB.

> cat n9.sql
select 1 from (select 1 from (select 1 from (select 1 from (select 1 from (select 1 from (select 1 from (select 1 from (select 1 from (select 1) a) a) a) a) a) a) a) a) a;