Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
None
-
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) |