Re: MySQL WorkBench 6.2.3 error with uppercase keywords

[Marco Del Corto]

Thanks for the reply.
In fact, I did more testing and the problem is not related to the keywords (case-sensitivity).
I saw that probably is due to the separation character of the commands
The commands are:
DROP TABLE IF EXISTS dedip.a1usr;
CREATE TABLE IF NOT EXISTS dedip.a1usr
(a1UsrId VARCHAR (50) NOT NULL ,
a1UsrName VARCHAR (255) NOT NULL ,
a1Tip CHAR (1) NOT NULL,
a1Create_DT DATETIME (6) DEFAULT CURRENT_TIMESTAMP(6),
a1Update_DT DATETIME (6) ON UPDATE CURRENT_TIMESTAMP(6),
PRIMARY KEY (a1UsrId));
Performing all commands together gives error, while if I select with the mouse commands one by one (so executing single command per time), error is not reported.
Seems to be a confusion between character separator ";" of "MySQL Workbench" and "mysql commandline" (?).
The strange thing is that this problem with the previous version (using the same sql script), did not attend.
Actual Version with error: MySQL Workbench Community (GPL) for Windows version 6.2.3 revision 12312 build 2280 (64 bit)
Previous version without error: MySQL Workbench Community (GPL) for Windows version 6.1.7 revision 11891 build 1788
Can you help to resolve this issue?
thank you