diff options
| author | unknown <bar@mysql.com> | 2005-03-28 14:01:57 +0500 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2005-03-28 14:01:57 +0500 |
| commit | f80b366f40cea4f4367c66e3423ec5a7370e5ed0 (patch) | |
| tree | de2a9f7a368ce2838081332de3e83ebcc4e47fe4 /mysql-test | |
| parent | 949875cb7b915de001f0c0754926ccbdbf0aba38 (diff) | |
| download | mariadb-git-f80b366f40cea4f4367c66e3423ec5a7370e5ed0.tar.gz | |
Bug#9425 A user variable doesn't always have implicit coercibility
Coercibility fixes for numeric types and not defined values were done.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/user_var.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/user_var.test | 7 |
2 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/user_var.result b/mysql-test/r/user_var.result index d82c17b0fe0..d8425899b77 100644 --- a/mysql-test/r/user_var.result +++ b/mysql-test/r/user_var.result @@ -193,3 +193,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 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); |