diff options
| author | kaa@polly.local <> | 2006-09-08 14:08:29 +0400 |
|---|---|---|
| committer | kaa@polly.local <> | 2006-09-08 14:08:29 +0400 |
| commit | 268c7a352280cf2e2bc334296866b46867777c64 (patch) | |
| tree | ecd49220ee2f3240b098af7a672ff3a7f0f6b541 /mysql-test/t/case.test | |
| parent | b6cd727ed1f722ae37f9302196f6f20121bbbb4d (diff) | |
| download | mariadb-git-268c7a352280cf2e2bc334296866b46867777c64.tar.gz | |
Bug #20924: CAST(expr as UNSIGNED) returns SIGNED value when used in various functions
- Honor unsigned_flag in the corresponding functions
- Use compare_int_signed_unsigned()/compare_int_unsigned_signed() instead of explicit comparison in GREATEST() and LEAST()
Diffstat (limited to 'mysql-test/t/case.test')
| -rw-r--r-- | mysql-test/t/case.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/case.test b/mysql-test/t/case.test index fd1b6e5247f..b868ae12b69 100644 --- a/mysql-test/t/case.test +++ b/mysql-test/t/case.test @@ -130,4 +130,10 @@ select min(a), min(case when 1=1 then a else NULL end), from t1 where b=3 group by b; drop table t1; +# +# Bug #20924: UNSIGNED values in CASE and COALESCE are treated as SIGNED +# +SELECT CASE 1 WHEN 1 THEN 18446744073709551615 ELSE 1 END; +SELECT COALESCE(18446744073709551615); + # End of 4.1 tests |