Update test results for udf

Remove STANDARD  define when compile udf_example.so


mysql-test/r/udf.result:
  Update results
mysql-test/t/udf.test:
  Update test try to create, use and drop a non existing function
  Disable the result from "reverse_lookup" as it is config dependent
sql/Makefile.am:
  Remove the "STANDARD" define when compiling udf_example.so

1 files changed, 9 insertions, 3 deletions

diff --git a/mysql-test/t/udf.test b/mysql-test/t/udf.test
index ebe21d20362..c9f22cf410b 100644
--- a/mysql-test/t/udf.test
+++ b/mysql-test/t/udf.test
@@ -17,9 +17,8 @@ drop table if exists t1;
 CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example.so';
 CREATE FUNCTION myfunc_double RETURNS REAL SONAME 'udf_example.so';
 
-# myfunc_int does not have a myfunc_int_init function and can 
-# not be loaded unless server is started with --allow-suspicious-udfs
 --error ER_CANT_FIND_DL_ENTRY
+CREATE FUNCTION myfunc_nonexist RETURNS INTEGER SONAME 'udf_example.so';
 CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME 'udf_example.so';
 CREATE FUNCTION sequence RETURNS INTEGER SONAME "udf_example.so";
 CREATE FUNCTION lookup RETURNS STRING SONAME 'udf_example.so';
@@ -33,6 +32,7 @@ select myfunc_double();
 select myfunc_double(1);
 select myfunc_double(78654);
 --error 1305
+select myfunc_nonexist();
 select myfunc_int();
 --error 0
 select lookup();
@@ -42,9 +42,14 @@ select lookup(127,0,0,1);
 select lookup("localhost");
 --error 0
 select reverse_lookup();
+
+# These two functions should return "localhost", but it's
+# depending on configuration, so just call them and don't log the result
+--disable_result_log
 select reverse_lookup("127.0.0.1");
---error 0
 select reverse_lookup(127,0,0,1);
+--enable_result_log
+
 select reverse_lookup("localhost");
 --error 0
 select avgcost();
@@ -94,6 +99,7 @@ drop procedure xxx2;
 DROP FUNCTION metaphon;
 DROP FUNCTION myfunc_double;
 --error ER_SP_DOES_NOT_EXIST
+DROP FUNCTION myfunc_nonexist;
 DROP FUNCTION myfunc_int;
 DROP FUNCTION sequence;
 DROP FUNCTION lookup;