[MDEV-17081] Make optimizer aware of Mdev-371 (long unique index) Created: 2018-08-28 Updated: 2022-02-22 |
|
| Status: | Stalled |
| Project: | MariaDB Server |
| Component/s: | Optimizer, Server |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Sachin Setiya (Inactive) | Assignee: | Sergei Golubchik |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||
| Description |
|
This mdev is about leveraging long unique index for blob in optimizer. Currently there are 2 approaches 1. fix ha_index_read_max(idx_map) to look for hash(blob column ) instead of actual blob. 2. Extend the where condition with DB_ROW_HASH_XX = hash(where long columns) |