Bug #20332 | SQL PREPARE does not accept a local variable name inside an SP | ||
---|---|---|---|
Submitted: | 8 Jun 2006 4:26 | Modified: | 8 Jun 2006 6:23 |
Reporter: | Arjen Lentz | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: Stored Routines | Severity: | S3 (Non-critical) |
Version: | 5.0.22 | OS: | Any (any) |
Assigned to: | CPU Architecture: | Any |
[8 Jun 2006 4:26]
Arjen Lentz
[8 Jun 2006 4:28]
Arjen Lentz
The error you actually get is: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'str; EXECUTE stat; END' at line 1
[8 Jun 2006 6:23]
Sveta Smirnova
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Because of this, we hope you add your comments to the original bug instead. Thank you for your interest in MySQL. Additional info: There is similar feature request: http://bugs.mysql.com/bug.php?id=17409