diff options
| author | unknown <holyfoot@deer.(none)> | 2006-03-01 15:50:15 +0400 |
|---|---|---|
| committer | unknown <holyfoot@deer.(none)> | 2006-03-01 15:50:15 +0400 |
| commit | b17bb278f760bdd646192eb6bff51ea5ad5c3975 (patch) | |
| tree | ea3d6bfe83560fbe84148a76e7d545dbe09c3d0c /mysql-test/t/bigint.test | |
| parent | 8a061aa6e3bed150e1e8c45e10369cbf79700911 (diff) | |
| download | mariadb-git-b17bb278f760bdd646192eb6bff51ea5ad5c3975.tar.gz | |
bug #9088 (bigint WHERE fails)
mysql-test/r/bigint.result:
test result
mysql-test/t/bigint.test:
testcase
sql/item.h:
unsigned_arg is a separate parameter now
sql/item_cmpfunc.cc:
we can get unsigned field from the signed Item - from string
like '1234'
Diffstat (limited to 'mysql-test/t/bigint.test')
| -rw-r--r-- | mysql-test/t/bigint.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/bigint.test b/mysql-test/t/bigint.test index 7871b3647e3..35cda11646a 100644 --- a/mysql-test/t/bigint.test +++ b/mysql-test/t/bigint.test @@ -270,3 +270,12 @@ VALUES (9, 99, 999, 9999, 99999, 999999, 9999999, 99999999, 999999999, SELECT * FROM t1; DROP TABLE t1; + +#bug #9088 BIGINT WHERE CLAUSE +create table t1 (bigint_col bigint unsigned); +insert into t1 values (17666000000000000000); +select * from t1 where bigint_col=17666000000000000000; +select * from t1 where bigint_col='17666000000000000000'; +drop table t1; + + |