# This test should work in embedded server after we fix mysqltest
-- source include/not_embedded.inc

--echo # Bug#22559575 "the statement (1) has no open cursor" pops sometimes with
--echo # prepared+query_cache
--echo #
--echo # Create relevent tables and call C API test cases
--echo # Setup

select VARIABLE_VALUE into @qcache_hit_val1 from
  information_schema.GLOBAL_STATUS  where VARIABLE_NAME = 'Qcache_hits';

--echo
--echo #Run C_API test case
--exec echo "$MYSQL_CLIENT_TEST --silent test_bug22559575" > $MYSQLTEST_VARDIR/log/mysql_client_test_qcache.out.log 2>&1
--exec $MYSQL_CLIENT_TEST --silent test_bug22559575 >> $MYSQLTEST_VARDIR/log/mysql_client_test_qcache.out.log 2>&1

select VARIABLE_VALUE into @qcache_hit_val2 from
  information_schema.GLOBAL_STATUS  where VARIABLE_NAME = 'Qcache_hits';
SELECT @qcache_hit_val2 - @qcache_hit_val1;