Skip to content
← Customer Feedback for Devart

Settings and activity

1 result found

  1. 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…)
    2 comments  ·  dbForge Studio for MySQL » Bugs  ·  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
    AdminDevart (_, Devart) responded

    This issue will be fixed in the next version 7.4. We will notify you once it’s available for downloading.

    An error occurred while saving the comment
    Max commented  · 

    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".

    Max shared this idea  ·