diff options
| author | cmiller@zippy.cornsilk.net <> | 2007-02-13 10:54:04 -0500 |
|---|---|---|
| committer | cmiller@zippy.cornsilk.net <> | 2007-02-13 10:54:04 -0500 |
| commit | 11e8f4873459ed70379c1d1e813fa126f25b40cd (patch) | |
| tree | dd32c329ae576946f3a73dda88aa8e45b367f5c6 /mysql-test/r/select.result | |
| parent | da9f2149dea1c20c5dc52d0de5bcd0ff19c99fc1 (diff) | |
| parent | 8dc8e07fcf38365eb268d3ce3edbdf29bde89323 (diff) | |
| download | mariadb-git-11e8f4873459ed70379c1d1e813fa126f25b40cd.tar.gz | |
Merge bk-internal.mysql.com:/home/bk/mysql-4.1
into zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-4.1-maint
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index f09143fcaa6..6dc971a953c 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -2819,3 +2819,20 @@ select min(key1) from t1 where key1 >= 0.3762 and rand() + 0.5 >= 0.5; min(key1) 0.37619999051094 DROP TABLE t1,t2; +create table t1(a bigint unsigned, b bigint); +insert into t1 values (0xfffffffffffffffff, 0xfffffffffffffffff), +(0x10000000000000000, 0x10000000000000000), +(0x8fffffffffffffff, 0x8fffffffffffffff); +Warnings: +Warning 1264 Data truncated; out of range for column 'a' at row 1 +Warning 1264 Data truncated; out of range for column 'b' at row 1 +Warning 1264 Data truncated; out of range for column 'a' at row 2 +Warning 1264 Data truncated; out of range for column 'b' at row 2 +Warning 1264 Data truncated; out of range for column 'b' at row 3 +select hex(a), hex(b) from t1; +hex(a) hex(b) +FFFFFFFFFFFFFFFF 7FFFFFFFFFFFFFFF +FFFFFFFFFFFFFFFF 7FFFFFFFFFFFFFFF +8FFFFFFFFFFFFFFF 7FFFFFFFFFFFFFFF +drop table t1; +End of 4.1 tests |