Note, you can use Flexvie.ws to materialize the get_column() output into another table, index that and use an inexpensive join to retrieve the data from the original table. It isn't a perfect solution, but it is a stop-gap to function based indexes.
Sent from my iPhone > On Feb 1, 2015, at 3:23 PM, Sergei Golubchik <s...@mariadb.org> wrote: > > Hi, Tom! > > To sum this thread up: > > * clunky syntax is unfortunate, but that's what SQL is, that'll probably > stay that way :( > > * A function to query a type of a value for a particular dynamic column, > COLUMN_GET_SQL() as you call it, that should be easy to do. > I've just created an issue for that: > https://mariadb.atlassian.net/browse/MDEV-7535 > feel free to add your comments there. > > * indexes for dynamic columns (even if not "as important"). This is > already existing MDEV-6017, but it's a much larger task than COLUMN_GET_SQL. > > * Input JSON directly - an existing task too, MDEV-7524 > > * And arrays were mentioned too, it's MDEV-6632 > > And while I'm not promising anything, I think that MDEV-7535 > (COLUMN_GET_SQL or something similar) has a good chance of being > implemented in 10.2. > > Regards, > Sergei > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
