[CONJ-880] metadata query performance correction Created: 2021-05-11  Updated: 2021-06-29  Resolved: 2021-05-11

Status: Closed
Project: MariaDB Connector/J
Component/s: metadata
Affects Version/s: 2.7
Fix Version/s: 2.7.3, 3.0.1-beta

Type: Bug Priority: Major
Reporter: Diego Dupin Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: 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.


Generated at Thu Feb 08 03:18:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.