Hi, Roberto! On Jan 28, Roberto Spadim wrote: > i think a good start is "expression indexes" and after json syntax to SQL > language, and some new functions to handle json/etc > > CREATE INDEX name ON table ( some_function(field) ) > maybe dynamic column functions, or json functions? or any function > deterministic (for example, NOW() function can't be used) > > and use it at WHERE clausules
> WHERE some_function(field) ='1234' <- use index > WHERE some_function(table.field) ='1234' > WHERE some_function(field) IN ( sub select ) > WHERE some_function(field) LIKE "blabla%" > WHERE some_function(field) LIKE "%blabla%" > WHERE some_function(field) LIKE "%blabla" See MDEV-6017 and linked issues. 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
