diff options
| author | bar@mysql.com <> | 2005-03-28 14:01:57 +0500 |
|---|---|---|
| committer | bar@mysql.com <> | 2005-03-28 14:01:57 +0500 |
| commit | e60daecc87f939a889e71fdb4306111007bc139f (patch) | |
| tree | de2a9f7a368ce2838081332de3e83ebcc4e47fe4 /mysql-test/r/user_var.result | |
| parent | 06bcfe8886383e41b01e526e390b3fdd68089341 (diff) | |
| download | mariadb-git-e60daecc87f939a889e71fdb4306111007bc139f.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/r/user_var.result')
| -rw-r--r-- | mysql-test/r/user_var.result | 7 |
1 files changed, 7 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 |