Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1398

MariaDB CS returns wrong values if query_cache_size is turned on

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.1.4
    • Icebox
    • MariaDB Server
    • None

    Description

      If you turn on the "query_cache_size" in a MariaDB Columnstore installation, the SELECT Statements will return wrong values.

      The first query will return the correct values, but after that every select query returns the values from the first (cached) query.
      For Example:
      Select * from A;
      -> return A
      Select * from B;
      -> return A;
      Select * from B;
      -> return A;
      [...]

      Disconnecting does not help, since the cache remains. After the cache is invalidated (e.g. after a reboot) only the first query is correct again.
      If you turn off the query cache everything works like a charm again.

      Tested with version 1.1.3 and 1.1.4

      Attachments

        Activity

          People

            Unassigned Unassigned
            t1mb3r Johanna Neumann
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.