# Bug#22559575 "the statement (1) has no open cursor" pops sometimes with
# prepared+query_cache
#
# Create relevent tables and call C API test cases
# Setup
select VARIABLE_VALUE into @qcache_hit_val1 from
information_schema.GLOBAL_STATUS  where VARIABLE_NAME = 'Qcache_hits';

#Run C_API test case
select VARIABLE_VALUE into @qcache_hit_val2 from
information_schema.GLOBAL_STATUS  where VARIABLE_NAME = 'Qcache_hits';
SELECT @qcache_hit_val2 - @qcache_hit_val1;
@qcache_hit_val2 - @qcache_hit_val1
1