Skip to content

Instantly share code, notes, and snippets.

Avatar
🤖
Working from home

Alexey Mogilyovkin ZeroICQ

🤖
Working from home
View GitHub Profile
View gsoc-final-report.md

Final report for GSoC 2019 with MariaDB

Student: Alexey Mogilyovkin
GitHub: @ZeroICQ
Organization: MariaDB
Project Title: Add support for Indexes on Expressions

About

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