summaryrefslogtreecommitdiff
path: root/mysql-test/t/partition_innodb.test
diff options
context:
space:
mode:
authorunknown <bar@bar.intranet.mysql.r18.ru>2006-06-22 18:51:50 +0500
committerunknown <bar@bar.intranet.mysql.r18.ru>2006-06-22 18:51:50 +0500
commitc06d8fa1c7b6696a587f444b73f173ed0d033782 (patch)
tree80f77b862f4f04770b5409ac34ce539dcbd410b3 /mysql-test/t/partition_innodb.test
parent54b38dd6b514a4a683dfd5376be3cb70b45b9a20 (diff)
parent4e138572a01afc7e88f1b3040d3c4a81012e298f (diff)
downloadmariadb-git-c06d8fa1c7b6696a587f444b73f173ed0d033782.tar.gz
Merge abarkov@bk-internal.mysql.com:/home/bk/mysql-5.1-kt
into mysql.com:/usr/home/bar/mysql-5.1.b20086 mysql-test/t/partition_innodb.test: Auto merged sql/field.cc: Auto merged sql/field.h: Auto merged
Diffstat (limited to 'mysql-test/t/partition_innodb.test')
-rw-r--r--mysql-test/t/partition_innodb.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/partition_innodb.test b/mysql-test/t/partition_innodb.test
index a31d0793565..51f5b0fec01 100644
--- a/mysql-test/t/partition_innodb.test
+++ b/mysql-test/t/partition_innodb.test
@@ -66,3 +66,15 @@ DROP TABLE IF EXISTS t0_definition;
DROP TABLE IF EXISTS t0_template;
--enable_warnings
+#
+# Bug#20086: Can't get data from key partitioned tables with VARCHAR key
+#
+create table t1 (id varchar(64) primary key) engine=innodb
+partition by key(id) partitions 5;
+insert into t1 values ('a');
+insert into t1 values ('aa');
+insert into t1 values ('aaa');
+select * from t1 where id = 'a';
+select * from t1 where id = 'aa';
+select * from t1 where id = 'aaa';
+drop table t1;