This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

JSON_SET

Hello,

I'm working with JSON functions and I have noticed that the following call returns NULL:

SELECT JSON_SET('{}', '$.age', 87); 

Shouldn't it return an object like MYSQL does? If not, what default value should I use to make sure the following UPDATE is working?

Also, is there any support for special JSON operators: -> and ->>?

Thanks, Sebi

Answer Answered by Ian Gilfillan in this comment.

I have reported this as MDEV-13324, you can follow the progress there

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.