skeema / skeema / 6241837645

92%

push

github

lint-dupe-index: flag spatial indexes w/o SRID in MySQL 8

This commit enhances lint-dupe-index to flag SPATIAL indexes which lack an
SRID attribute. MySQL 8+ won't use such indexes in queries, as per
https://dev.mysql.com/doc/refman/8.0/en/spatial-index-optimization.html

Although such indexes aren't technically "duplicates", they do fall into the
general category of unnecessary indexes, which is lint-dupe-index's overall
purpose.

This change only takes effect if the database server is actually running
MySQL 8+. Older versions of MySQL lack the SRID attribute and do not ignore
spatial indexes in this way. And although MariaDB does support SRIDs, their
syntax and functionality differs from MySQL's, and they do not affect indexing
in this manner.

23 of 23 new or added lines in 1 file covered. (100.0%)

9414 of 10097 relevant lines covered (93.24%)

1.11 hits per line