Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.7
-
None
Description
Metadata query can sometime do full table scan.
To avoid that query must be slightly be simplifyed.
Since tables in mariadb cannot have no catalog, a simplification of query with empty catalog (not null) will be considered as no-op, returning empty resultset as expected. This will permit condition to always have strict equality (or like if needed), avoiding fulltable scan.