diff options
| author | ramil@ram-book.(none) <> | 2005-05-06 20:11:01 +0500 |
|---|---|---|
| committer | ramil@ram-book.(none) <> | 2005-05-06 20:11:01 +0500 |
| commit | bec93d485b5370548edd578e48fd94564c97abd0 (patch) | |
| tree | 97a1e363b0952bb4030ebcf1c28955670d7826fb /mysql-test/t/innodb.test | |
| parent | 6a476984687e22c5b6501d99f57b949ff1a174d3 (diff) | |
| download | mariadb-git-bec93d485b5370548edd578e48fd94564c97abd0.tar.gz | |
fix for bug #4082: Integer lengths cause truncation with DISTINCT CONCAT and InnoDB
Diffstat (limited to 'mysql-test/t/innodb.test')
| -rw-r--r-- | mysql-test/t/innodb.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test index 7501889127a..4e18cfb224b 100644 --- a/mysql-test/t/innodb.test +++ b/mysql-test/t/innodb.test @@ -1168,3 +1168,12 @@ alter table t1 add key (c1,c2,c1); --error 1060 alter table t1 add key (c1,c1,c2); drop table t1; + +# +# Bug #4082: integer truncation +# + +create table t1(a int(1) , b int(1)) engine=innodb; +insert into t1 values ('1111', '3333'); +select distinct concat(a, b) from t1; +drop table t1; |