Student: Alexey Mogilyovkin
GitHub: @ZeroICQ
Organization: MariaDB
Project Title: Add support for Indexes on Expressions
My task was to add support for indexes on expression. At the very beginning it was split into two steps:
- Add expression matching into the optimizer, use it for generated columns. So the following request should work and use index
CREATE TABLE t1 (a int, b int, INDEX (a/2+b));