Now in MariaDB if in a query [NOT] IN predicate is used with a long list of values, SEL_TREE structures are built to check if the range access based on this predicate can be used. Building SEL_TREE structures takes a huge amount of memory. In this case it will be better to transform the predicate into [NOT] IN subquery with built over the list of values in its FROM list.

This project includes addition of to SQL of MariaDB and implementation of the above-mentioned transformation.

Organization

Student

Galina Shalygina

Mentors

  • Igor Babaev
close

2017