Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-880

metadata query performance correction

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            diego dupin Diego Dupin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.