summaryrefslogtreecommitdiff
path: root/mysql-test/r/ndb_basic.result
diff options
context:
space:
mode:
authorunknown <tomas@poseidon.ndb.mysql.com>2004-10-28 15:43:16 +0000
committerunknown <tomas@poseidon.ndb.mysql.com>2004-10-28 15:43:16 +0000
commitbfa4db4d40590c6177a6e25b61f529ce6a391f2d (patch)
treecd61de585171c86a44105cef6a5a8cb5940ad660 /mysql-test/r/ndb_basic.result
parent5f630d1f9c3acc1c3ffb6a93d330f730f7e2619e (diff)
downloadmariadb-git-bfa4db4d40590c6177a6e25b61f529ce6a391f2d.tar.gz
ndb_basic.result:
forgot to commit new result mysql-test/r/ndb_basic.result: forgot to commit new result
Diffstat (limited to 'mysql-test/r/ndb_basic.result')
-rw-r--r--mysql-test/r/ndb_basic.result16
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_basic.result b/mysql-test/r/ndb_basic.result
index 37083beac89..604084a72c2 100644
--- a/mysql-test/r/ndb_basic.result
+++ b/mysql-test/r/ndb_basic.result
@@ -545,3 +545,19 @@ c127 int,
c128 int,
primary key(c1)) engine=ndb;
drop table t1;
+create table t1 (
+a1234567890123456789012345678901234567890 int primary key,
+a12345678901234567890123456789a1234567890 int,
+index(a12345678901234567890123456789a1234567890)
+) engine=ndb;
+show tables;
+Tables_in_test
+t1
+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;
+id select_type table type possible_keys key key_len ref rows Extra
+1 SIMPLE t1 ref a12345678901234567890123456789a1234567890 a12345678901234567890123456789a1234567890 5 const 10 Using where
+select * from t1 where a12345678901234567890123456789a1234567890=2;
+a1234567890123456789012345678901234567890 a12345678901234567890123456789a1234567890
+5 2
+drop table t1;