diff options
| author | unknown <hf@deer.(none)> | 2005-02-21 19:20:05 +0400 |
|---|---|---|
| committer | unknown <hf@deer.(none)> | 2005-02-21 19:20:05 +0400 |
| commit | cd32f9609555291b7a59f8de1bd767ae28120454 (patch) | |
| tree | 84d3fc85af1db9c809044e40b5ef8eb312c32f5d /mysql-test/t/cast.test | |
| parent | 453809f3a4ac7c18b3606a9c85e6d61ac050d410 (diff) | |
| download | mariadb-git-cd32f9609555291b7a59f8de1bd767ae28120454.tar.gz | |
Tests modified to coved decimal-related code
mysql-test/r/analyse.result:
test result extended
mysql-test/r/cast.result:
test result extended
mysql-test/r/func_group.result:
test result extended
mysql-test/r/subselect.result:
test result extended
mysql-test/t/analyse.test:
test extended
mysql-test/t/cast.test:
test extended
mysql-test/t/func_group.test:
test extended
mysql-test/t/subselect.test:
test extended
Diffstat (limited to 'mysql-test/t/cast.test')
| -rw-r--r-- | mysql-test/t/cast.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/cast.test b/mysql-test/t/cast.test index 23bba7d5aff..5866431e687 100644 --- a/mysql-test/t/cast.test +++ b/mysql-test/t/cast.test @@ -118,3 +118,11 @@ select date_add(cast('2004-12-30 12:00:00' as date), interval 0 hour); select timediff(cast('2004-12-30 12:00:00' as time), '12:00:00'); # Still we should not throw away "days" part of time value select timediff(cast('1 12:00:00' as time), '12:00:00'); + +#decimal-related additions +select cast('1.2' as decimal(3,2)); +select 1e18 * cast('1.2' as decimal(3,2)); +select cast(cast('1.2' as decimal(3,2)) as signed); +set @v1=1e18; +select cast(@v1 as decimal(22, 2)); +select cast(-1e18 as decimal(22,2)); |