- a new construction called TABLE VALUE CONSTRUCTOR (TVC)
- optimization that transforms IN predicate into IN subquery that uses TVC.
-construct of TVC (including the case when TVC is used as derived table)
Non-terminals in sql_yacc.yy: table_value_constructor, derived_table_value_constructor
Optimization works when IN predicate is used in WHERE clause of the query or when it is ON expression of some join. It also works when IN predicate is in derived tables, CTEs and subqueries.
Here is the list of commits on github: