diff options
| author | unknown <jani@ua141d10.elisa.omakaista.fi> | 2005-05-24 17:50:17 +0300 |
|---|---|---|
| committer | unknown <jani@ua141d10.elisa.omakaista.fi> | 2005-05-24 17:50:17 +0300 |
| commit | 801c2c275a471ac37a6e520f6da737ffd2dbb16f (patch) | |
| tree | 734139d99ed478ef8c746889730080fcd1d27a04 /mysql-test | |
| parent | b36f9f2eeded87ee629619f0c35840f3bec10013 (diff) | |
| download | mariadb-git-801c2c275a471ac37a6e520f6da737ffd2dbb16f.tar.gz | |
Added a test case for Bug#8009.
sql/item.cc:
Fixed Bug#8009.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/select.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/select.test | 9 |
2 files changed, 15 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; |