diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2022-12-07 09:39:46 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2022-12-07 09:39:46 +0200 |
| commit | 9e27e53dfac1c911a593065a0fcadc5729957d29 (patch) | |
| tree | 679b56d887a1544264a9f872a2d8b3a7659cd8f2 /mysql-test/main/having.result | |
| parent | b7ae4d442aa32752798f1d3b6122c35c4ebe2d07 (diff) | |
| parent | 9044e016c54762300beb2cd609b41c285bbf8794 (diff) | |
| download | mariadb-git-9e27e53dfac1c911a593065a0fcadc5729957d29.tar.gz | |
Merge 10.6 into 10.7
Diffstat (limited to 'mysql-test/main/having.result')
| -rw-r--r-- | mysql-test/main/having.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/having.result b/mysql-test/main/having.result index ac26d69543d..d7cbadd5e75 100644 --- a/mysql-test/main/having.result +++ b/mysql-test/main/having.result @@ -834,13 +834,13 @@ test.t1 analyze status Engine-independent statistics collected test.t1 analyze status OK explain SELECT t, next_seq_value() r FROM t1 FORCE INDEX(t) GROUP BY t HAVING r = 1 ORDER BY t1.u; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 8 Using temporary; Using filesort +1 SIMPLE t1 index NULL t 5 NULL 8 Using temporary; Using filesort SELECT t, next_seq_value() r FROM t1 FORCE INDEX(t) GROUP BY t HAVING r = 1 ORDER BY t1.u; t r 10 1 12 1 -14 1 -16 1 +15 1 +17 1 DROP TABLE t1; DROP FUNCTION next_seq_value; DROP TABLE series; |