summaryrefslogtreecommitdiff
path: root/mysql-test/r/udf.result
diff options
context:
space:
mode:
authorunknown <cmiller@zippy.(none)>2006-07-03 11:35:58 -0400
committerunknown <cmiller@zippy.(none)>2006-07-03 11:35:58 -0400
commit058cad784851301664b8b3e26cad93093b446357 (patch)
tree26ea19d61c67c7cded9c9c925281f64ddf51bc14 /mysql-test/r/udf.result
parent9baac37a621a48602c02f8e4516143d0cbed9d65 (diff)
parent90ff8fbd380154b6b1efef259d326185277f007a (diff)
downloadmariadb-git-058cad784851301664b8b3e26cad93093b446357.tar.gz
Merge zippy.(none):/home/cmiller/work/mysql/merge/mysql-5.0
into zippy.(none):/home/cmiller/work/mysql/merge/mysql-5.1 BitKeeper/etc/ignore: auto-union client/mysqldump.c: Auto merged mysql-test/r/bdb.result: Auto merged mysql-test/r/type_timestamp.result: Auto merged mysql-test/r/udf.result: Auto merged mysql-test/t/bdb.test: Auto merged mysql-test/t/type_timestamp.test: Auto merged mysys/my_lib.c: Auto merged sql/log_event.cc: Auto merged sql/log_event.h: Auto merged sql/table.cc: Auto merged mysql-test/r/func_time.result: manual merge mysql-test/r/mysqldump.result: manual merge mysql-test/t/func_time.test: manual merge mysql-test/t/mysqldump.test: manual merge sql/log.cc: manual merge sql/sp_head.cc: manual merge sql/sql_table.cc: manual merge
Diffstat (limited to 'mysql-test/r/udf.result')
-rw-r--r--mysql-test/r/udf.result18
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/udf.result b/mysql-test/r/udf.result
index 01aa8539262..d6b96bae8d4 100644
--- a/mysql-test/r/udf.result
+++ b/mysql-test/r/udf.result
@@ -76,6 +76,24 @@ call XXX2();
metaphon(testval)
HL
drop procedure xxx2;
+CREATE TABLE bug19904(n INT, v varchar(10));
+INSERT INTO bug19904 VALUES (1,'one'),(2,'two'),(NULL,NULL),(3,'three'),(4,'four');
+SELECT myfunc_double(n) AS f FROM bug19904;
+f
+49.00
+50.00
+NULL
+51.00
+52.00
+SELECT metaphon(v) AS f FROM bug19904;
+f
+ON
+TW
+NULL
+0R
+FR
+DROP TABLE bug19904;
+End of 5.0 tests.
DROP FUNCTION metaphon;
DROP FUNCTION myfunc_double;
DROP FUNCTION myfunc_nonexist;