diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2017-09-26 16:43:54 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2017-09-27 10:22:15 +0200 |
| commit | f0e9bebd278b27e05d9c66746420b48535f2b86e (patch) | |
| tree | a9d5c71f55945bf02fd92bba11897022c6f3178a /mysql-test/r/variables.result | |
| parent | 5b01b88e2ba6a51a5e9112badb45210e3b2e3dc4 (diff) | |
| download | mariadb-git-f0e9bebd278b27e05d9c66746420b48535f2b86e.tar.gz | |
MDEV-13897 SELECT @a := MAX(col) FROM t requires full index scanmariadb-10.1.28
fix some old bad merge
Diffstat (limited to 'mysql-test/r/variables.result')
| -rw-r--r-- | mysql-test/r/variables.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/variables.result b/mysql-test/r/variables.result index fef3e4a3e9e..b621fc13ee4 100644 --- a/mysql-test/r/variables.result +++ b/mysql-test/r/variables.result @@ -1544,7 +1544,7 @@ one 1 explain SELECT 1 as 'one' FROM t1 GROUP BY @a:= (SELECT ROUND(f1) FROM t1 WHERE f1 = 0); id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using temporary; Using filesort +1 PRIMARY t1 ALL NULL NULL NULL NULL 2 2 SUBQUERY t1 ALL NULL NULL NULL NULL 2 Using where SELECT 1 as 'one' FROM t1 GROUP BY @a:= (SELECT ROUND(f1) FROM t1 WHERE f1 = 0); one @@ -1555,7 +1555,7 @@ one set sql_buffer_result=1; explain SELECT 1 as 'one' FROM t1 GROUP BY @a:= (SELECT ROUND(f1) FROM t1 WHERE f1 = 0); id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using temporary; Using filesort +1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using temporary 2 SUBQUERY t1 ALL NULL NULL NULL NULL 2 Using where SELECT 1 as 'one' FROM t1 GROUP BY @a:= (SELECT ROUND(f1) FROM t1 WHERE f1 = 0); one |