diff options
| author | bar@mysql.com <> | 2004-11-05 14:07:12 +0400 |
|---|---|---|
| committer | bar@mysql.com <> | 2004-11-05 14:07:12 +0400 |
| commit | 813b2f3357a15dd31f03af075e0b207fba41ef0f (patch) | |
| tree | 4cad20e61c49c9e2ea60a3231a53e38939295a6c /mysql-test/r/user_var.result | |
| parent | 5543f312b046045d7cdbd0e3357ba4ea0efe3842 (diff) | |
| download | mariadb-git-813b2f3357a15dd31f03af075e0b207fba41ef0f.tar.gz | |
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(<uservariable content NULL>, ...) now works fine too.
Diffstat (limited to 'mysql-test/r/user_var.result')
| -rw-r--r-- | mysql-test/r/user_var.result | 4 |
1 files changed, 4 insertions, 0 deletions
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 |