maria-discuss team mailing list archive

[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