diff options
author | Igor Babaev <igor@askmonty.org> | 2019-02-19 02:44:27 -0800 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2019-02-19 02:45:24 -0800 |
commit | 8283d7d2c029cb520214ae7d33af8851acc80892 (patch) | |
tree | 9e805ca20f1913fa005a59db48aeeb7f02ad31fe /mysql-test/main/union.result | |
parent | 7fe1ca7ed6ac5d28a51a08749c8cdc64495d6911 (diff) | |
download | mariadb-git-8283d7d2c029cb520214ae7d33af8851acc80892.tar.gz |
MDEV-7486: Condition pushdown from HAVING into WHERE
Optimized the code that removed multiple equalities pushed from HAVING
into WHERE. Now this removal is postponed until all multiple equalities
are eliminated in substitute_for_best_equal_field().
Diffstat (limited to 'mysql-test/main/union.result')
-rw-r--r-- | mysql-test/main/union.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/union.result b/mysql-test/main/union.result index a7688a14fce..e975e0f8591 100644 --- a/mysql-test/main/union.result +++ b/mysql-test/main/union.result @@ -2332,7 +2332,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY NULL NULL NULL NULL NULL NULL NULL NULL No tables used 2 UNION NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Warnings: -Note 1003 /* select#1 */ select 1 AS `1`,2 AS `2` union all /* select#2 */ select 1 AS `i`,count(0) AS `COUNT(*)` from `test`.`t2` where 0 group by 1 having 1 +Note 1003 /* select#1 */ select 1 AS `1`,2 AS `2` union all /* select#2 */ select 1 AS `i`,count(0) AS `COUNT(*)` from `test`.`t2` where 0 group by 1 having multiple equal(10, `i`) DROP TABLE t1,t2; # # Start of 10.3 tests |