← Back to team overview

maria-discuss team mailing list archive

Re: virtual columns and indexes on attributes in JSON objects

 

there're others things we could support:
https://mariadb.atlassian.net/browse/MDEV-4430
https://mariadb.atlassian.net/browse/MDEV-4414
https://mariadb.atlassian.net/browse/MDEV-4419



2014-04-26 13:18 GMT-03:00 Federico Razzoli <federico_raz@xxxxxxxx>:

> If you can write an expression which returns the JSON attribute, yes, the
> (trivial) technique I described in the post can do that. I think that MySQL
> 5.7 JSON functions are not yet in MariaDB. But maybe they can be added
> easily?
> Or again, maybe you can use MariaDB 10 regexp's?
>
> Federico
>
>
> --------------------------------------------
> El sáb, 26/4/14, MARK CALLAGHAN <mdcallag@xxxxxxxxx> escribió:
>
>  Asunto: [Maria-discuss] virtual columns and indexes on attributes in JSON
>      objects
>  Para: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
>  Fecha: sábado, 26 de abril, 2014 17:29
>
>  Does the support for
>  virtual columns allow an index to be created on an attribute
>  in a JSON object stored in a BLOB column?
>
>
> http://falseisnotnull.wordpress.com/2014/04/25/descending-indexes-in-mariadb
>
>  https://mariadb.com/kb/en/virtual-columns/
>
>  --
>  Mark Callaghan
>  mdcallag@xxxxxxxxx
>
>  -----Adjunto en línea a continuación-----
>
>  _______________________________________________
>  Mailing list: https://launchpad.net/~maria-discuss
>  Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>  Unsubscribe : https://launchpad.net/~maria-discuss
>  More help   : https://help.launchpad.net/ListHelp
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle

References