diff options
Diffstat (limited to 'mysql-test/main/join.result')
-rw-r--r-- | mysql-test/main/join.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/main/join.result b/mysql-test/main/join.result index 6ff294906e7..0a0afe6c71d 100644 --- a/mysql-test/main/join.result +++ b/mysql-test/main/join.result @@ -1268,6 +1268,10 @@ id select_type table type possible_keys key key_len ref rows Extra INSERT INTO t1 VALUES (3,'b'),(4,NULL),(5,'c'),(6,'cc'),(7,'d'), (8,'dd'),(9,'e'),(10,'ee'); INSERT INTO t2 VALUES (2,NULL); +ANALYZE TABLE t1,t2; +Table Op Msg_type Msg_text +test.t1 analyze status OK +test.t2 analyze status OK FLUSH STATUS; SELECT * FROM t1 JOIN t2 ON t1.v = t2.v WHERE t2.v IS NULL ORDER BY 1; pk v pk v |