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/r/cast.result | |
| 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/r/cast.result')
| -rw-r--r-- | mysql-test/r/cast.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result index 10eb597fa68..57821699f68 100644 --- a/mysql-test/r/cast.result +++ b/mysql-test/r/cast.result @@ -187,3 +187,19 @@ timediff(cast('2004-12-30 12:00:00' as time), '12:00:00') select timediff(cast('1 12:00:00' as time), '12:00:00'); timediff(cast('1 12:00:00' as time), '12:00:00') 24:00:00 +select cast('1.2' as decimal(3,2)); +cast('1.2' as decimal(3,2)) +1.20 +select 1e18 * cast('1.2' as decimal(3,2)); +1e18 * cast('1.2' as decimal(3,2)) +1.2e+18 +select cast(cast('1.2' as decimal(3,2)) as signed); +cast(cast('1.2' as decimal(3,2)) as signed) +1 +set @v1=1e18; +select cast(@v1 as decimal(22, 2)); +cast(@v1 as decimal(22, 2)) +1000000000000000000.00 +select cast(-1e18 as decimal(22,2)); +cast(-1e18 as decimal(22,2)) +-1000000000000000000.00 |