| Bug #76761 | Syntax error: missing 'at text suffix' | ||
|---|---|---|---|
| Submitted: | 20 Apr 2015 19:54 | Modified: | 19 Jan 2017 23:28 |
| Reporter: | Piotr Szawdyński | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench: SQL Editor | Severity: | S1 (Critical) |
| Version: | 6.3.2/6.2.5 | OS: | Windows (Microsoft Windows 7 Home Premium Service Pack 1) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | WBBugReporter | ||
[22 Apr 2015 13:04]
MySQL Verification Team
Thank you for the bug report.
[19 Jan 2017 23:28]
Christine Cole
Posted by developer: Fixed as of the upcoming Workbench 6.3.9 release, and here's the changelog entry: Stored procedures containing valid query syntax produced syntax errors. Thank you for the bug report.
Description: Valid syntax is threated as invalid. Can't update or create valid stored procedure. How to repeat: CREATE PROCEDURE `new_procedure` () BEGIN DECLARE a INT; SET @b = 1; select col1 into @b,a from tab LIMIT 1; END Suggested fix: Revert patch which caused this bug.