From 4bb358924cce7f3e6c4bffbc228441cb16131cb1 Mon Sep 17 00:00:00 2001
From: "cmiller@zippy.(none)" <>
Date: Thu, 8 Jun 2006 13:25:28 -0400
Subject: Bug#19904: UDF: not initialized *is_null per row

The is_null value was initialized once and thereafter only set to indicate
NULL, and never unset to indicate not-NULL.

Now set is_null to false, in addition to only setting it to true when the value
in question is null.
---
 mysql-test/t/udf.test | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'mysql-test/t/udf.test')

diff --git a/mysql-test/t/udf.test b/mysql-test/t/udf.test
index e2556692612..f3be08c8537 100644
--- a/mysql-test/t/udf.test
+++ b/mysql-test/t/udf.test
@@ -99,6 +99,17 @@ delimiter ;//
 call XXX2();
 drop procedure xxx2;
 
+#
+# Bug#19904: UDF: not initialized *is_null per row
+#
+
+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;
+SELECT metaphon(v) AS f FROM bug19904;
+DROP TABLE bug19904;
+
+--echo End of 5.0 tests.
 
 #
 # Drop the example functions from udf_example
@@ -114,3 +125,4 @@ DROP FUNCTION lookup;
 DROP FUNCTION reverse_lookup;
 DROP FUNCTION avgcost;
 
+
-- 
cgit v1.2.1