[MDEV-16058] Unnecessary computations for SPATIAL INDEX Created: 2018-04-30 Updated: 2018-04-30 Resolved: 2018-04-30 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.2.2, 10.3.0 |
| Fix Version/s: | 10.3.7 |
| Type: | Bug | Priority: | Major |
| Reporter: | Marko Mäkelä | Assignee: | Marko Mäkelä |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | gis, performance, upstream | ||
| Description |
|
In InnoDB, spatial index (R-tree) records always start with a field whose length is DATA_MBR_LEN. This field is unfortunately declared as variable-length, so its length is always encoded. The InnoDB functions dict_index_copy_rec_order_prefix() and rec_copy_prefix_to_buf() are treating spatial indexes as if they could have any number of fields or any length for the first field. |