diff options
| author | unknown <cmiller@zippy.(none)> | 2006-06-22 08:58:37 -0400 |
|---|---|---|
| committer | unknown <cmiller@zippy.(none)> | 2006-06-22 08:58:37 -0400 |
| commit | 41af8b9e3bcf8bd7862156576c1fb46cd00f1c21 (patch) | |
| tree | 839d6e33d2167f65037b82da1708b2b5b4b1c5a0 /mysql-test/r | |
| parent | 88547195e82c6577445dcdb71968e828f82677bb (diff) | |
| parent | e2495206b276d6aaeb506ed135016112532d71e3 (diff) | |
| download | mariadb-git-41af8b9e3bcf8bd7862156576c1fb46cd00f1c21.tar.gz | |
Merge bk-internal.mysql.com:/home/bk/mysql-5.0-maint
into zippy.(none):/home/cmiller/work/mysql/mysql-5.0__bug19904
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/udf.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/udf.result b/mysql-test/r/udf.result index be52fd7f87c..484c42c41bf 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; |