It appears that dbForge does not currently fully support the JSON_VALUE() function syntax which includes the ability to utilize the RETURNING type arguments (allow CASTing of returned value to a specific data type). When attempting to create a generated column in the Table Editor or using the function and syntax in a stored function or procedure, neither allows the code to be saved because the interpreter views it as an error. This is valuable new function in that eliminates the need to write more verbose SQL code for type casting.
For more information on the new function and syntax:
https://dev.mysql.com/doc/refman/8.0/en ... json-value
Support was added by the language for this function as of MySQL 8.0.21.
Code: Select all
mysql> SELECT JSON_VALUE('{"item": "shoes", "price": "49.95"}', '$.price' RETURNING DECIMAL(4,2)) AS price;
+-------+
| price |
+-------+
| 49.95 |
+-------+