Bug #8410 Stored procedure crash if function references information_schema

• Submitted: 9 Feb 2005 22:23
• Modified: 21 Apr 2005 14:07
• Reporter: Peter Gulutzan
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Assigned to: Per-Erik Martin
• CPU Architecture: Any

[9 Feb 2005 22:23] Peter Gulutzan

Description:
If a function contains a reference to an information_schema table, then a statement which uses the function will crash.

How to repeat:
mysql> create function f46 () returns char(10) return (select min(table_name) from information_schema.tables)//
Query OK, 0 rows affected (0.00 sec)

mysql> create table t46 (s1 int)//
Query OK, 0 rows affected (0.01 sec)

mysql> insert into t46 values (1)//
Query OK, 1 row affected (0.00 sec)

mysql> select f46() from t46//
ERROR 2013 (HY000): Lost connection to MySQL server during query

[9 Feb 2005 22:25] MySQL Verification Team

Thank you for the bug report.

[21 Apr 2005 14:07] Per-Erik Martin

No longer repeatable.