gistfile1.txt

MariaDB [test]> create function json_get_item returns string soname 'ha_connect.so';
Query OK, 0 rows affected (0.02 sec)

MariaDB [test]> select json_get_item('{"id": 1}', 'id:*');
+------------------------------------+
| json_get_item('{"id": 1}', 'id:*') |
+------------------------------------+
| NULL                               |
+------------------------------------+
1 row in set (0.00 sec)

MariaDB [test]> select @@version;
+----------------------+
| @@version            |
+----------------------+
| 10.2.7-MariaDB-debug |
+----------------------+
1 row in set (0.00 sec)