dolt icon indicating copy to clipboard operation
dolt copied to clipboard

Add support for function indexes

Open wilj opened this issue 3 years ago • 2 comments

Request: Add support for MySQL function/expression indexes such as:

CREATE INDEX idx1 ON t1 ((col1 + col2));
CREATE INDEX idx2 ON t1 (lower(trim(col3)));

wilj avatar Mar 08 '22 21:03 wilj

Thanks. We will investigate and get back to you.

As I said in the other ticket, materializing this as a column with a trigger is the workaround.

timsehn avatar Mar 08 '22 22:03 timsehn

This is a relatively large feature and will take quite a bit of work to implement. I'm adding it to the roadmap.

zachmu avatar Mar 15 '22 00:03 zachmu