maria-discuss team mailing list archive

[Anders Karlsson <anders@xxxxxxxxxx>]

Sure, you can do that. You do it by creating a persistent virtual column 
on the attribute, using COLUMN_GET probably, and then creating a column 
on that. In a presentation on JSON and MySQL / MariaDB I show a simple 
example of this:
http://www.slideshare.net/blueskarlsson/using-json-with-mariadb-and-mysql
See slide 20

Of course we would like this to be even smarter, but this is what is 
available and works as we speak.

/Karlsson
MARK CALLAGHAN skrev 2014-04-26 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 <mailto:mdcallag@xxxxxxxxx>
>
>
> _______________________________________________
> 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


--

Anders Karlsson, Senior Sales Engineer
SkySQL | t: +46 708-608-121 | Skype: drdatabase