diff options
| author | holyfoot@deer.(none) <> | 2006-03-01 15:50:15 +0400 |
|---|---|---|
| committer | holyfoot@deer.(none) <> | 2006-03-01 15:50:15 +0400 |
| commit | dc052a3a0048da961906a50add352b6ba4ab8bd7 (patch) | |
| tree | ea3d6bfe83560fbe84148a76e7d545dbe09c3d0c /mysql-test/t/bigint.test | |
| parent | f641a919432b21b478b2ab4b1bacd1096d6c6d84 (diff) | |
| download | mariadb-git-dc052a3a0048da961906a50add352b6ba4ab8bd7.tar.gz | |
bug #9088 (bigint WHERE fails)
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; + + |