Skip to content

Instantly share code, notes, and snippets.

Working from home

Alexey Mogilyovkin ZeroICQ

Working from home
View GitHub Profile

Final report for GSoC 2019 with MariaDB

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:

  1. 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));