Thursday, March 12, 2015

Questions for old posts at https://blogs.oracle.com/svetasmirnova/

Tomorrow will be my last day at Oracle. Next day I would not have access to my working blog at https://blogs.oracle.com/svetasmirnova/ But content will stay.

However Oracle blogs require manual managing of comments and I simply don't expect my colleagues will have time to do it in timely manner. Therefore if you have questions about my old blog posts just write them here together with the URL of the post.

3 comments:

  1. Hi. I filed a feature request for MariaDB, asking them to include your JSON UDF's. I report the link here, so if anyone is interested, they can vote the request.

    https://mariadb.atlassian.net/browse/MDEV-8538

    ciao!
    Federico

    ReplyDelete
    Replies
    1. Thank you, Federico! I will watch the report.

      Delete
    2. Hi, I saw there was still a bug with json_search and arrays. Will this patch help you?

      https://gist.github.com/xplinscott/10a8e3e82c39c6c07c09

      > select json_search('[[1,2,3],[4,5,6]]', '4');
      outputs:
      $[1][0]


      It seems to fix most things for me, except a case of empty arrays:

      > select json_search('[[],[4,5,6]]', '4');
      outputs:
      $[0][0]

      Delete