From f80b366f40cea4f4367c66e3423ec5a7370e5ed0 Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 28 Mar 2005 14:01:57 +0500 Subject: Bug#9425 A user variable doesn't always have implicit coercibility Coercibility fixes for numeric types and not defined values were done. --- mysql-test/t/user_var.test | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'mysql-test/t') diff --git a/mysql-test/t/user_var.test b/mysql-test/t/user_var.test index 2f526dc9a46..cfeb5f228a7 100644 --- a/mysql-test/t/user_var.test +++ b/mysql-test/t/user_var.test @@ -122,3 +122,10 @@ drop table t1; # set @var= NULL ; select FIELD( @var,'1it','Hit') as my_column; + +# +# Bug#9425 A user variable doesn't always have implicit coercibility +# +select @v, coercibility(@v); +set @v1=null, @v2=1, @v3=1.1, @v4=now(); +select coercibility(@v1),coercibility(@v2),coercibility(@v3),coercibility(@v4); -- cgit v1.2.1 From e62a32a3a5e0459bb4bcdc6597e986c6c4eecf67 Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 28 Mar 2005 14:17:47 +0500 Subject: union.test: Bug #6519 UNION with collation binary and latin1_swedish_ci fails now Prove that this problem was fixed with bug9425 fix too. mysql-test/t/union.test: Bug #6519 UNION with collation binary and latin1_swedish_ci fails now Prove that this problem was fixed with bug9425 fix too. --- mysql-test/t/union.test | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'mysql-test/t') diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index 82f26f63254..26dc544482e 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -711,3 +711,9 @@ select * from ((select * from t1 limit 1) union (select * from t1 limit 1) union select * from ((((select * from t1))) union (select * from t1) union (select * from t1)) a; select * from ((select * from t1) union (((select * from t1))) union (select * from t1)) a; drop table t1; + +# +# Bugs#6519 UNION with collation binary and latin1_swedish_ci fails +# +set @val:=6; +select concat('value is: ', @val) union select 'some text'; -- cgit v1.2.1