diff options
Diffstat (limited to 'mysql-test/main/subselect.result')
| -rw-r--r-- | mysql-test/main/subselect.result | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/main/subselect.result b/mysql-test/main/subselect.result index 393e9be8c22..3bd23a49cdb 100644 --- a/mysql-test/main/subselect.result +++ b/mysql-test/main/subselect.result @@ -3106,6 +3106,7 @@ insert into t2(a, c, b) values (1,10,'359'), (2,10,'35988'), (3,10,'35989'); insert into t2(a, c, b) values (4,10,'360'), (5,10,'35998'), (6,10,'35999'); analyze table t1; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected test.t1 analyze status OK explain SELECT sql_no_cache t1.a, r.a, r.b FROM t1 LEFT JOIN t2 r ON r.a = (SELECT t2.a FROM t2 WHERE t2.c = t1.a AND t2.b <= '359899' |