Skip to content
← dbForge Studio for MySQL

I suggest you...

dbForge Studio for MySQL: Bugs

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Make editor to understand the statement in stored procedures and functions: CAST(value AS JSON)

7 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Max shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Ryan commented  ·   ·  Report

    When will this be fixed? I have updated to the latest version and this is still an issue.

  • Max commented  ·   ·  Report

    For example, the following stored procedure executes well, even in dbForge (when it is before saved by MySQL Workbench).

    CREATE DEFINER=`root`@`localhost` PROCEDURE `validJsonUsageDemonstration`()
    BEGIN

    DECLARE a JSON;

    SET a = CAST('{"id": 1, "phone": "123456"}' AS JSON);

    SELECT a -> '$.phone';
    END

    But attempting to save the procedure in dbForge gives the error "Unexpected symbol 'json'" with the message "Object has invalid source text and cannot be saved".