summaryrefslogtreecommitdiff
path: root/mysql-test/t/ndb_index_unique.test
diff options
context:
space:
mode:
authorunknown <pekka@mysql.com>2006-02-07 19:57:31 +0100
committerunknown <pekka@mysql.com>2006-02-07 19:57:31 +0100
commit245948654d4b44c3428ef47a8c228808a49a40f8 (patch)
tree8db25cb7ed0774e8cdd8c82a32df65855275d4b3 /mysql-test/t/ndb_index_unique.test
parent895d09469aefdbd8f98737db2a43b1029ba206f1 (diff)
downloadmariadb-git-245948654d4b44c3428ef47a8c228808a49a40f8.tar.gz
ndb - bug#15918 fix
mysql-test/r/ndb_index_unique.result: bug#15918 fix mysql-test/t/ndb_index_unique.test: bug#15918 fix ndb/src/kernel/blocks/dbacc/Dbacc.hpp: bug#15918 fix sql/ha_ndbcluster.cc: bug#15918 fix sql/ha_ndbcluster.h: bug#15918 fix
Diffstat (limited to 'mysql-test/t/ndb_index_unique.test')
-rw-r--r--mysql-test/t/ndb_index_unique.test14
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_index_unique.test b/mysql-test/t/ndb_index_unique.test
index 2185276c2c6..8561b3794c4 100644
--- a/mysql-test/t/ndb_index_unique.test
+++ b/mysql-test/t/ndb_index_unique.test
@@ -309,4 +309,18 @@ select * from t1 where code = '12' and month = 4 and year = 2004 ;
drop table t1;
+# bug#15918 Unique Key Limit in NDB Engine
+
+create table t1 (a int primary key, b varchar(1000) not null, unique key (b))
+engine=ndb charset=utf8;
+
+insert into t1 values (1, repeat(_utf8 0xe288ab6474, 200));
+--error 1062
+insert into t1 values (2, repeat(_utf8 0xe288ab6474, 200));
+select a, sha1(b) from t1;
+
+# perl -e 'print pack("H2000","e288ab6474"x200)' | sha1sum
+
+drop table t1;
+
# End of 4.1 tests