diff options
Diffstat (limited to 'mysql-test/main/query_cache.result')
| -rw-r--r-- | mysql-test/main/query_cache.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/main/query_cache.result b/mysql-test/main/query_cache.result index fc7ca726c48..7f728b20286 100644 --- a/mysql-test/main/query_cache.result +++ b/mysql-test/main/query_cache.result @@ -2207,6 +2207,22 @@ Variable_name Value Qcache_queries_in_cache 0 DROP FUNCTION foo; drop table t1; +# +# MDEV-22301 JSON_TABLE: Queries are not inserted into query cache. +# +create table t1 (a text); +insert into t1 values ('{"a":"foo"}'); +flush status; +SHOW STATUS LIKE 'Qcache_inserts'; +Variable_name Value +Qcache_inserts 0 +select * from t1, json_table(t1.a, '$' columns (f varchar(20) path '$.a')) as jt; +a f +{"a":"foo"} foo +SHOW STATUS LIKE 'Qcache_inserts'; +Variable_name Value +Qcache_inserts 1 +drop table t1; restore defaults SET GLOBAL query_cache_type= default; SET GLOBAL query_cache_size=@save_query_cache_size; |