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)