diff options
| author | ramil/ram@myoffice.izhnet.ru <> | 2007-01-18 11:13:13 +0400 |
|---|---|---|
| committer | ramil/ram@myoffice.izhnet.ru <> | 2007-01-18 11:13:13 +0400 |
| commit | a2303ea3feb0958c2c6c2e72a22c22b46923c456 (patch) | |
| tree | aa8bfc4b3e8c3b9c6d35b45e17980b394965cdea /mysql-test/r/select.result | |
| parent | 2a0e2d1d3860aea8f6b6b4287214b491c87c8cce (diff) | |
| parent | 5c42e6838843b5210b2682f25bfb932f717eeb49 (diff) | |
| download | mariadb-git-a2303ea3feb0958c2c6c2e72a22c22b46923c456.tar.gz | |
Merge mysql.com:/usr/home/ram/work/bug22533/my50-bug22533
into mysql.com:/usr/home/ram/work/bug22533/my51-bug22533
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 f24b109d75a..c133637f20b 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -2811,6 +2811,23 @@ SELECT i='1e+01',i=1e+01, i in (1e+01,1e+01), i in ('1e+01','1e+01') FROM t1; i='1e+01' i=1e+01 i in (1e+01,1e+01) i in ('1e+01','1e+01') 1 1 1 1 DROP TABLE t1; +create table t1(a bigint unsigned, b bigint); +insert into t1 values (0xfffffffffffffffff, 0xfffffffffffffffff), +(0x10000000000000000, 0x10000000000000000), +(0x8fffffffffffffff, 0x8fffffffffffffff); +Warnings: +Warning 1264 Out of range value adjusted for column 'a' at row 1 +Warning 1264 Out of range value adjusted for column 'b' at row 1 +Warning 1264 Out of range value adjusted for column 'a' at row 2 +Warning 1264 Out of range value adjusted for column 'b' at row 2 +Warning 1264 Out of range value adjusted 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 CREATE TABLE t1 ( K2C4 varchar(4) character set latin1 collate latin1_bin NOT NULL default '', K4N4 varchar(4) character set latin1 collate latin1_bin NOT NULL default '0000', |