summaryrefslogtreecommitdiff
path: root/mysql-test/r/user_var.result
diff options
context:
space:
mode:
authorunknown <bar@eagle.intranet.mysql.r18.ru>2005-03-28 14:08:25 +0500
committerunknown <bar@eagle.intranet.mysql.r18.ru>2005-03-28 14:08:25 +0500
commit1747bead1de12963b451f8052363c7809dfda34c (patch)
tree0fd1c204e45e8864b786c805dc76f43e5a083635 /mysql-test/r/user_var.result
parent104d81883f8d2425002c48178663e3e72d351b16 (diff)
parentf80b366f40cea4f4367c66e3423ec5a7370e5ed0 (diff)
downloadmariadb-git-1747bead1de12963b451f8052363c7809dfda34c.tar.gz
Merge eagle.intranet.mysql.r18.ru:/home/bar/mysql-4.1
into eagle.intranet.mysql.r18.ru:/home/bar/mysql-5.0 mysql-test/r/user_var.result: Auto merged mysql-test/t/user_var.test: Auto merged sql/item_func.cc: Auto merged
Diffstat (limited to 'mysql-test/r/user_var.result')
-rw-r--r--mysql-test/r/user_var.result7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/user_var.result b/mysql-test/r/user_var.result
index 4b2eef20a6b..bd261751938 100644
--- a/mysql-test/r/user_var.result
+++ b/mysql-test/r/user_var.result
@@ -204,3 +204,10 @@ set @var= NULL ;
select FIELD( @var,'1it','Hit') as my_column;
my_column
0
+select @v, coercibility(@v);
+@v coercibility(@v)
+NULL 2
+set @v1=null, @v2=1, @v3=1.1, @v4=now();
+select coercibility(@v1),coercibility(@v2),coercibility(@v3),coercibility(@v4);
+coercibility(@v1) coercibility(@v2) coercibility(@v3) coercibility(@v4)
+2 2 2 2