It seems that MySQL for Visual Studio does not work properly with the built-in function named 'format'. I'm unable to edit the procedure below
To reproduce:
- add this procedure to a database using some other tool. Run it, see that it's valid
- open using MySQL for Visual Studio v1.2.9, click save and receive these errors:
Syntax Error: line 4:16 no viable alternative at input'('. Expected column_name. line 4:26 mismatched input ')' expecting END
line 6:1 extraneous input 'END' expecting EndOfFile
Any thoughts? Some other problem?
-------------------
CREATE DEFINER=`root`@`localhost` PROCEDURE `test`()
BEGIN
SELECT FORMAT(123.456,2);
END
-------------------
Visual Studio Community 2019, v16.4.3
MySQL .NET Connector v8.0.19
MySQL for Visual Studio v1.2.9
MySQL Community v5.7.29.0
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_format