mirror of
https://github.com/MariaDB/server.git
synced 2026-02-08 19:58:40 +01:00
cc219b3dfc
Queries having the form select * from t1 where (a+1, b) IN ((1,1),(2,2),(3,3)); where a+1 is a virtual column will now be optimized to use that virtual column such that the above becomes select * from t1 where (vcol, b) IN ((1,1),(2,2),(3,3)); In general, vcol substitution will occur when a row itself contains the matching vcol expression. The optimizer will not only inspect the left-hand argument to IN for the matching expression, but will also unpack and inspect the left-hand argument when it is a row. |
||
|---|---|---|
| .. | ||
| inc | ||
| r | ||
| t | ||
| disabled.def | ||