diff options
| author | Igor Babaev <igor@askmonty.org> | 2019-02-03 22:26:39 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2019-02-03 22:26:39 -0800 |
| commit | cfd2646c3152bbefe11e381c00b701a49cf5c4ef (patch) | |
| tree | ed982828dff13de0d20c5b43ec0b1cb736a211c7 /mysql-test/main/key.result | |
| parent | 37deed3f37561f264f65e162146bbc2ad35fb1a2 (diff) | |
| download | mariadb-git-cfd2646c3152bbefe11e381c00b701a49cf5c4ef.tar.gz | |
Fixed the results after the merge of 10.4 into bb-10.4-mdev16188.
Diffstat (limited to 'mysql-test/main/key.result')
| -rw-r--r-- | mysql-test/main/key.result | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/main/key.result b/mysql-test/main/key.result index 42eca8d6cf0..d1d751c1c91 100644 --- a/mysql-test/main/key.result +++ b/mysql-test/main/key.result @@ -605,12 +605,13 @@ VALUES (2,2), (2,3), (2,1), (3,1), (4,1), (4,2), (4,3), (4,4), (4,5), (4,6); ANALYZE table t1; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected test.t1 analyze status OK EXPLAIN SELECT 1 FROM t1 AS t1_outer WHERE (SELECT max(b) FROM t1 GROUP BY a HAVING a < 2) > 12; id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY NULL NULL NULL NULL NULL NULL NULL Impossible WHERE -2 SUBQUERY t1 range NULL a 5 NULL 4 Using index for group-by +2 SUBQUERY t1 index NULL a 10 NULL 15 Using index SELECT 1 as RES FROM t1 AS t1_outer WHERE (SELECT max(b) FROM t1 GROUP BY a HAVING a < 2) > 12; RES |