diff options
| author | unknown <lars@mysql.com/black.(none)> | 2006-10-10 21:58:24 +0200 |
|---|---|---|
| committer | unknown <lars@mysql.com/black.(none)> | 2006-10-10 21:58:24 +0200 |
| commit | aa788dce98116c3be534433f28dc285b61e53b96 (patch) | |
| tree | 3beee7d0a0e8c6940a23bf21ac40c5ebef99534e /mysql-test/r | |
| parent | a6a93d6f19d8e97a4fb4b9b7e51dd76c4dd6c6a6 (diff) | |
| parent | dc62ff5560fcd8596cba19b767cfb39396309d4f (diff) | |
| download | mariadb-git-aa788dce98116c3be534433f28dc285b61e53b96.tar.gz | |
Merge mysql.com:/home/bkroot/mysql-4.1-rpl
into mysql.com:/home/bk/MERGE/mysql-4.1-merge
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/cast.result | 3 | ||||
| -rw-r--r-- | mysql-test/r/ps.result | 14 |
2 files changed, 10 insertions, 7 deletions
diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result index 68687670e17..101b9ac3f7e 100644 --- a/mysql-test/r/cast.result +++ b/mysql-test/r/cast.result @@ -264,6 +264,9 @@ cast(repeat('1',20) as signed) -7335632962598440505 Warnings: Warning 1105 Cast to signed converted positive out-of-range integer to it's negative complement +select cast(19999999999999999999 as unsigned); +cast(19999999999999999999 as unsigned) +18446744073709551615 select cast(1.0e+300 as signed int); cast(1.0e+300 as signed int) 9223372036854775807 diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result index 78752622db7..4abc7bb7709 100644 --- a/mysql-test/r/ps.result +++ b/mysql-test/r/ps.result @@ -340,7 +340,7 @@ set @precision=10000000000; select rand(), cast(rand(10)*@precision as unsigned integer) from t1; rand() cast(rand(10)*@precision as unsigned integer) -- 6570515219 +- 6570515220 - 1282061302 - 6698761160 - 9647622201 @@ -351,23 +351,23 @@ prepare stmt from set @var=1; execute stmt using @var; rand() cast(rand(10)*@precision as unsigned integer) cast(rand(?)*@precision as unsigned integer) -- 6570515219 - +- 6570515220 - - 1282061302 - - 6698761160 - - 9647622201 - set @var=2; execute stmt using @var; rand() cast(rand(10)*@precision as unsigned integer) cast(rand(?)*@precision as unsigned integer) -- 6570515219 6555866465 -- 1282061302 1223466192 -- 6698761160 6449731873 +- 6570515220 6555866465 +- 1282061302 1223466193 +- 6698761160 6449731874 - 9647622201 8578261098 set @var=3; execute stmt using @var; rand() cast(rand(10)*@precision as unsigned integer) cast(rand(?)*@precision as unsigned integer) -- 6570515219 9057697559 +- 6570515220 9057697560 - 1282061302 3730790581 -- 6698761160 1480860534 +- 6698761160 1480860535 - 9647622201 6211931236 drop table t1; deallocate prepare stmt; |