Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-31519

Impossible WHERE noticed after reading const tables is logged as not using index

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      I have some queries which generate "Impossible WHERE noticed after reading const tables", which is perfectly good.
      If log_queries_not_using_indexes=on
      these queries are logged as well. But this is not "true". Sure no index is used, as the query returns before, but this should not be logged in the slow query log

      Attachments

        Activity

          People

            Unassigned Unassigned
            mokraemer Marc
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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