Bug #2272 Crash if update with variable name in stored procedure
Submitted: 3 Jan 2004 16:41 Modified: 8 Jan 2004 0:34
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.0 OS:Linux (SuSE 8.2)
Assigned to: Per-Erik Martin CPU Architecture:Any

[3 Jan 2004 16:41] Peter Gulutzan
Description:
If I use "UPDATE ... SET variable_name = value" rather than the more normal/sane 
"UPDATE ... SET column_name = value", I get a crash. 

How to repeat:
mysql> delimiter | 
mysql> create table t (s1 int)| 
Query OK, 0 rows affected (0.29 sec) 
 
mysql> insert into t values (5)| 
Query OK, 1 row affected (0.00 sec) 
 
mysql> create procedure pt () begin declare v int; update t set v = 7; end| 
Query OK, 0 rows affected, 1 warning (0.63 sec) 
 
mysql> call pt()| 
ERROR 2013 (HY000): Lost connection to MySQL server during query
[8 Jan 2004 0:34] Per-Erik Martin
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html