Re: MYSQL Workbench New Syntax Error - 6.3.6

[Mike Lischke]

Antoine,

can you give us more details please? Where exactly do you get the syntax error (SP editor, sql editor)?

I tried with the current GA version and get no error for this code (in the sql editor):

delimiter $$
create procedure p1 ()
begin
declare code int;
declare msg text;

GET DIAGNOSTICS CONDITION 1
code = RETURNED_SQLSTATE, msg = MESSAGE_TEXT; 
end;

In the SP editor you can omit the delimiter command.

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/