summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <tomas@poseidon.ndb.mysql.com>2004-10-28 15:35:06 +0000
committerunknown <tomas@poseidon.ndb.mysql.com>2004-10-28 15:35:06 +0000
commit1aa81f3818023eaf95b46b795a7c4222850e46d1 (patch)
tree65a119e785c5cca9cf691d3cb15e41001f9d07b5 /mysql-test
parente3ac81bebf547b2031982134131ded3090cbe623 (diff)
downloadmariadb-git-1aa81f3818023eaf95b46b795a7c4222850e46d1.tar.gz
test that attribute name truncation works
exposed the attribute name size limit for handler added field name truncation to ndb handler mysql-test/t/ndb_basic.test: test that attribute name truncation works ndb/include/ndbapi/ndbapi_limits.h: exposed the attribute name size limit for handler sql/ha_ndbcluster.cc: added field name truncation to ndb handler
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/t/ndb_basic.test15
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_basic.test b/mysql-test/t/ndb_basic.test
index 0d4bffce80d..f5bed3dcdff 100644
--- a/mysql-test/t/ndb_basic.test
+++ b/mysql-test/t/ndb_basic.test
@@ -507,3 +507,18 @@ c127 int,
c128 int,
primary key(c1)) engine=ndb;
drop table t1;
+
+#
+# test max size of attribute name and truncation
+#
+
+create table t1 (
+a1234567890123456789012345678901234567890 int primary key,
+a12345678901234567890123456789a1234567890 int,
+index(a12345678901234567890123456789a1234567890)
+) engine=ndb;
+show tables;
+insert into t1 values (1,1),(2,1),(3,1),(4,1),(5,2),(6,1),(7,1);
+explain select * from t1 where a12345678901234567890123456789a1234567890=2;
+select * from t1 where a12345678901234567890123456789a1234567890=2;
+drop table t1;