null_key.test, null_key.result:

  Modified the test case for patch of the bug #12144
  to display status of Handler_read_next before and
  after the tested query.


mysql-test/r/null_key.result:
  Modified the test case for patch of the bug #12144
  to display status of Handler_read_next before and
  after the tested query.
mysql-test/t/null_key.test:
  Modified the test case for patch of the bug #12144
  to display status of Handler_read_next before and
  after the tested query.

1 files changed, 27 insertions, 3 deletions

diff --git a/mysql-test/t/null_key.test b/mysql-test/t/null_key.test
index 4952d6ac8e2..228b00d528a 100644
--- a/mysql-test/t/null_key.test
+++ b/mysql-test/t/null_key.test
@@ -200,21 +200,45 @@ drop table t1;
 CREATE TABLE t1 (a int);
 CREATE TABLE t2 (a int, b int, INDEX idx(a));
 CREATE TABLE t3 (b int, INDEX idx(b));
+CREATE TABLE t4 (b int, INDEX idx(b));
 INSERT INTO t1 VALUES (1), (2), (3), (4);
 INSERT INTO t2 VALUES (1, 1), (3, 1);
 INSERT INTO t3 VALUES 
   (NULL), (NULL), (NULL), (NULL), (NULL),
-  (NULL), (NULL), (NULL), (NULL), (NULL),
-  (2);
+  (NULL), (NULL), (NULL), (NULL), (NULL);
+INSERT INTO t4 SELECT * FROM t3;
+INSERT INTO t3 SELECT * FROM t4;
+INSERT INTO t4 SELECT * FROM t3;
+INSERT INTO t3 SELECT * FROM t4;
+INSERT INTO t4 SELECT * FROM t3;
+INSERT INTO t3 SELECT * FROM t4;
+INSERT INTO t4 SELECT * FROM t3;
+INSERT INTO t3 SELECT * FROM t4;
+INSERT INTO t4 SELECT * FROM t3;
+INSERT INTO t3 SELECT * FROM t4;
+INSERT INTO t4 SELECT * FROM t3;
+INSERT INTO t3 SELECT * FROM t4;
+INSERT INTO t4 SELECT * FROM t3;
+INSERT INTO t3 SELECT * FROM t4;
+INSERT INTO t4 SELECT * FROM t3;
+INSERT INTO t3 SELECT * FROM t4;
+INSERT INTO t3 VALUES (2), (3);
+
 ANALYZE table t1, t2, t3;
 
+SELECT COUNT(*) FROM t3;
+
 EXPLAIN SELECT SQL_CALC_FOUND_ROWS * FROM t1 LEFT JOIN t2 ON t1.a=t2.a
                                              LEFT JOIN t3 ON t2.b=t3.b;
+SHOW STATUS LIKE "handler_read%";
+
 
 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LEFT JOIN t2 ON t1.a=t2.a
                                      LEFT JOIN t3 ON t2.b=t3.b;
 
+SHOW STATUS LIKE "handler_read%";
+
 SELECT FOUND_ROWS();
 
-DROP TABLE t1,t2,t3;
+DROP TABLE t1,t2,t3,t4;
 # End of 4.1 tests