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

QUERY CACHE - Query Cache And Limit Clause

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Incomplete
    • 10.0.10
    • N/A
    • None

    Description

      In reading about the query cache, I came across an undocumented situation.

      https://mariadb.com/kb/en/query-cache/

      Basically, the cache should consume queries that always return the same results. With that said, I have noticed that the query cache will cache a query with a LIMIT clause without an ORDER BY clause. This seems incorrect because the LIMIT could return different results for different queries.

      For completeness sake, I would suggest not caching queries that use a LIMIT without an ORDER BY clause.

      Attachments

        Activity

          People

            Unassigned Unassigned
            belugabehr BELUGABEHR
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.