diff options
| author | unknown <msvensson@neptunus.(none)> | 2006-03-10 12:12:08 +0100 |
|---|---|---|
| committer | unknown <msvensson@neptunus.(none)> | 2006-03-10 12:12:08 +0100 |
| commit | 4fb909838b9eadbb9fc0b13772487b118bbc7f77 (patch) | |
| tree | 2868820fd79467e3c4135b46118b13585c176632 /mysql-test/r/udf.result | |
| parent | f53afa23e6d5ac33a733dc1bf07344dc59c79098 (diff) | |
| download | mariadb-git-4fb909838b9eadbb9fc0b13772487b118bbc7f77.tar.gz | |
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
Diffstat (limited to 'mysql-test/r/udf.result')
| -rw-r--r-- | mysql-test/r/udf.result | 15 |
1 files changed, 8 insertions, 7 deletions
diff --git a/mysql-test/r/udf.result b/mysql-test/r/udf.result index 19f67eda429..ce9271224dc 100644 --- a/mysql-test/r/udf.result +++ b/mysql-test/r/udf.result @@ -1,8 +1,9 @@ drop table if exists t1; CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example.so'; CREATE FUNCTION myfunc_double RETURNS REAL SONAME 'udf_example.so'; +CREATE FUNCTION myfunc_nonexist RETURNS INTEGER SONAME 'udf_example.so'; +ERROR HY000: Can't find function 'myfunc_nonexist' in library CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME 'udf_example.so'; -ERROR HY000: Can't find function 'myfunc_int_init' in library CREATE FUNCTION sequence RETURNS INTEGER SONAME "udf_example.so"; CREATE FUNCTION lookup RETURNS STRING SONAME 'udf_example.so'; CREATE FUNCTION reverse_lookup @@ -17,8 +18,11 @@ myfunc_double(1) select myfunc_double(78654); myfunc_double(78654) 54.00 +select myfunc_nonexist(); +ERROR 42000: FUNCTION test.myfunc_nonexist does not exist select myfunc_int(); -ERROR 42000: FUNCTION test.myfunc_int does not exist +myfunc_int() +0 select lookup(); ERROR HY000: Wrong arguments to lookup; Use the source select lookup("127.0.0.1"); @@ -32,11 +36,7 @@ lookup("localhost") select reverse_lookup(); ERROR HY000: Wrong number of arguments to reverse_lookup; Use the source select reverse_lookup("127.0.0.1"); -reverse_lookup("127.0.0.1") -localhost select reverse_lookup(127,0,0,1); -reverse_lookup(127,0,0,1) -localhost select reverse_lookup("localhost"); reverse_lookup("localhost") NULL @@ -78,8 +78,9 @@ HL drop procedure xxx2; DROP FUNCTION metaphon; DROP FUNCTION myfunc_double; +DROP FUNCTION myfunc_nonexist; +ERROR 42000: FUNCTION test.myfunc_nonexist does not exist DROP FUNCTION myfunc_int; -ERROR 42000: FUNCTION test.myfunc_int does not exist DROP FUNCTION sequence; DROP FUNCTION lookup; DROP FUNCTION reverse_lookup; |