--source include/have_udf.inc
#
# To run this tests the "sql/udf_example.c" need to be compiled into
# udf_example.so and LD_LIBRARY_PATH should be setup to point out where
# the library are.
#

set GLOBAL query_cache_size=1355776;

--disable_warnings
drop table if exists t1;
--enable_warnings

#
# Bug # 28921 - caching should not kick in
#

--replace_result $UDF_EXAMPLE_LIB UDF_EXAMPLE_LIB
eval CREATE FUNCTION metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_LIB";
flush status;
create table t1 (a char);
select metaphon('MySQL') from t1;
show status like 'Qcache_hits';
select metaphon('MySQL') from t1;
show status like 'Qcache_hits';
drop table if exists t1;