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

Insert queries using CURDATE in query cache

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      I'm not sure, if the entries in the query cache have an expiry time, if so, queries using CURDATE/CURRENT_DATE/... could also be inserted in the cache an last there up to 24 hours.
      If you have many queries in the form
      select ... WHERE `date` between (CURRENT_DATE - INTERVAL 1 WEEK) AND CURRENT_DATE()
      the cache is not used.

      Attachments

        Activity

          People

            Unassigned Unassigned
            mokraemer Marc
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.