From 813b2f3357a15dd31f03af075e0b207fba41ef0f Mon Sep 17 00:00:00 2001 From: "bar@mysql.com" <> Date: Fri, 5 Nov 2004 14:07:12 +0400 Subject: user_var.result, user_var.test: My previous change that "set @a=NULL" doesn't change charset fixed 'Bug #6321' as well. Prove with a new test that FIELD(, ...) now works fine too. --- mysql-test/r/user_var.result | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'mysql-test/r/user_var.result') diff --git a/mysql-test/r/user_var.result b/mysql-test/r/user_var.result index 2750478c1c5..659c392e153 100644 --- a/mysql-test/r/user_var.result +++ b/mysql-test/r/user_var.result @@ -195,3 +195,7 @@ SET @`v`:=_ucs2 0x006100620063 COLLATE ucs2_general_ci; SET TIMESTAMP=10000; insert into t2 values (@v); drop table t1, t2; +set @var= NULL ; +select FIELD( @var,'1it','Hit') as my_column; +my_column +0 -- cgit v1.2.1