diff options
| author | unknown <jani@ua141d10.elisa.omakaista.fi> | 2005-05-24 18:23:31 +0300 |
|---|---|---|
| committer | unknown <jani@ua141d10.elisa.omakaista.fi> | 2005-05-24 18:23:31 +0300 |
| commit | edcc645b8e03bcd60012a871ead7175067b72c0a (patch) | |
| tree | 7140d32ffca9ffe6574e9f22ed7ba2560f778e6c | |
| parent | 8643958c5f303e5135543c9bc1b8cbf5b25bcf7c (diff) | |
| parent | 801c2c275a471ac37a6e520f6da737ffd2dbb16f (diff) | |
| download | mariadb-git-edcc645b8e03bcd60012a871ead7175067b72c0a.tar.gz | |
Merge jamppa@bk-internal.mysql.com:/home/bk/mysql-4.1
into ua141d10.elisa.omakaista.fi:/home/my/bk/mysql-4.1
| -rw-r--r-- | mysql-test/r/select.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/select.test | 9 | ||||
| -rw-r--r-- | sql/item.cc | 1 |
3 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index c39d1a322e4..f828759672a 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -2509,3 +2509,9 @@ AND FK_firma_id = 2; COUNT(*) 0 drop table t1; +CREATE TABLE t1 (b BIGINT(20) UNSIGNED NOT NULL, PRIMARY KEY (b)); +INSERT INTO t1 VALUES (0x8000000000000000); +SELECT b FROM t1 WHERE b=0x8000000000000000; +b +9223372036854775808 +DROP TABLE t1; diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test index 0634323cef7..3877e67de41 100644 --- a/mysql-test/t/select.test +++ b/mysql-test/t/select.test @@ -2051,3 +2051,12 @@ SELECT COUNT(*) FROM t1 WHERE AND FK_firma_id = 2; drop table t1; + +# +# Test for Bug#8009, SELECT failed on bigint unsigned when using HEX +# + +CREATE TABLE t1 (b BIGINT(20) UNSIGNED NOT NULL, PRIMARY KEY (b)); +INSERT INTO t1 VALUES (0x8000000000000000); +SELECT b FROM t1 WHERE b=0x8000000000000000; +DROP TABLE t1; diff --git a/sql/item.cc b/sql/item.cc index 59785813566..c43421117e5 100644 --- a/sql/item.cc +++ b/sql/item.cc @@ -2107,6 +2107,7 @@ Item_varbinary::Item_varbinary(const char *str, uint str_length) *ptr=0; // Keep purify happy collation.set(&my_charset_bin, DERIVATION_COERCIBLE); fixed= 1; + unsigned_flag= 1; } longlong Item_varbinary::val_int() |