[MDEV-12002] Make ICP work with non-persistent virtual columns Created: 2017-02-06 Updated: 2018-02-14 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Optimizer |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Sergei Petrunia | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
It should be possible to use Index Condition Pushdown on non-stored virtual columns. The column value is part of the index, so it's possible to unpack it back to the table record and evaluate the ICP condition. However mysql-5.7 doesn't do that: We (MariaDB) are about to inherit this property when we backport indexed virtual columns from MySQL. This task is about lifiting this limitation. |