MySQL Forums
Forum List  »  MySQL for Visual Studio

Error with built-in function 'format'
Posted by: Nate Marler
Date: January 20, 2020 08:03AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Error with built-in function 'format'
306
January 20, 2020 08:03AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.