From bfa4db4d40590c6177a6e25b61f529ce6a391f2d Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 28 Oct 2004 15:43:16 +0000 Subject: ndb_basic.result: forgot to commit new result mysql-test/r/ndb_basic.result: forgot to commit new result --- mysql-test/r/ndb_basic.result | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'mysql-test/r/ndb_basic.result') 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; -- cgit v1.2.1