From f20c56a9e7cc12a65068392ee733fff2ff4b805a Mon Sep 17 00:00:00 2001 From: unknown Date: Wed, 1 Jun 2005 09:48:25 -0700 Subject: Fix handling of NULL fields in FIELD(). (Bug #10944) mysql-test/r/func_str.result: Update results mysql-test/t/func_str.test: Add regression tests sql/item_func.cc: Handle NULL as first argument to FIELD() --- mysql-test/r/func_str.result | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'mysql-test/r/func_str.result') diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index 5405dbf53d9..ea1efbc7c0a 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -783,3 +783,9 @@ id aes_decrypt(str, 'bar') 1 foo 2 NULL DROP TABLE t1, t2; +select field(0,NULL,1,0), field("",NULL,"bar",""), field(0.0,NULL,1.0,0.0); +field(0,NULL,1,0) field("",NULL,"bar","") field(0.0,NULL,1.0,0.0) +3 3 3 +select field(NULL,1,2,NULL), field(NULL,1,2,0); +field(NULL,1,2,NULL) field(NULL,1,2,0) +0 0 -- cgit v1.2.1