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

    Details

    • Sprint:
      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

            • Assignee:
              varun Varun Gupta
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: