diff options
| author | unknown <ramil@ram-book.(none)> | 2005-05-06 20:11:01 +0500 |
|---|---|---|
| committer | unknown <ramil@ram-book.(none)> | 2005-05-06 20:11:01 +0500 |
| commit | a56921bbe041bbe28e0e5d4ede1681f1e5448c06 (patch) | |
| tree | 97a1e363b0952bb4030ebcf1c28955670d7826fb /mysql-test/t/innodb.test | |
| parent | a67043dbd812c2cf4da0950d1b12bf91ee3af14d (diff) | |
| download | mariadb-git-a56921bbe041bbe28e0e5d4ede1681f1e5448c06.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; |