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

Queries which start with WITH clause do not get inserted into query cache

    XMLWordPrintable

Details

    • 10.2.6-1

    Description

      MariaDB [test]> create table t1 (i int);
      Query OK, 0 rows affected (0.41 sec)
       
      MariaDB [test]> with cte as (select * from t1) select * from cte;
      Empty set (0.01 sec)
       
      MariaDB [test]> show status like 'Qcache%';
      +-------------------------+---------+
      | Variable_name           | Value   |
      +-------------------------+---------+
      | Qcache_free_blocks      | 1       |
      | Qcache_free_memory      | 1031080 |
      | Qcache_hits             | 0       |
      | Qcache_inserts          | 0       |
      | Qcache_lowmem_prunes    | 0       |
      | Qcache_not_cached       | 0       |
      | Qcache_queries_in_cache | 0       |
      | Qcache_total_blocks     | 1       |
      +-------------------------+---------+
      8 rows in set (0.00 sec)
       
      MariaDB [test]> select @@query_cache_type, @@query_cache_size;
      +--------------------+--------------------+
      | @@query_cache_type | @@query_cache_size |
      +--------------------+--------------------+
      | ON                 |            1048576 |
      +--------------------+--------------------+
      1 row in set (0.00 sec)
      

      Attachments

        Activity

          People

            varun Varun Gupta (Inactive)
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.