← Back to team overview

maria-discuss team mailing list archive

Re: virtual columns and indexes on attributes in JSON objects


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:
See slide 20

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

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?


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