skeema / skeema / 17112649332

92%

push

github

lower_case_table_names=2: workaround for recent MariaDB change

When the database server uses lower_case_table_names=2, MariaDB 10.11+
releases from May 2025 onwards seem to have odd behavior with column
information_schema.routines.routine_schema: mixed-case schema names always
come back downcased now, and WHERE clauses on this column only match downcased
schema names as well. This breaks Skeema's introspection of routines in this
very specific situation.

As a workaround, we force a case-insensitive comparison during introspection
of routines if using lower_case_table_names=2 in MariaDB 10.11.13+.

This introspection change is harmless for unaffected MariaDB versions, so no
need to target specific point releases beyond gating the minimum 10.11
affected. But for sake of completeness, the affected versions are:
* MariaDB 10.11: 10.11.13+
* MariaDB 11.4:  11.4.7+
* All GA releases of MariaDB 11.8 and beyond (e.g. 12.0, ...)

The MariaDB change is almost certainly related to MDEV-14432, but the exact
cause is not yet clear. I will file a new MariaDB bug within the next couple
weeks when time permits.

13 of 15 new or added lines in 2 files covered. (86.67%)

10810 of 11631 relevant lines covered (92.94%)

1.11 hits per line