diff options
| author | Galina Shalygina <galina.shalygina@mariadb.com> | 2019-03-23 15:28:22 +0300 |
|---|---|---|
| committer | Galina Shalygina <galina.shalygina@mariadb.com> | 2019-04-04 18:06:56 +0300 |
| commit | ae15f91f227015b3e1ad3f566db9396232cf0a3f (patch) | |
| tree | 28fa79f3fe624576ef3351f897b77558e7207330 /mysql-test/main/having.result | |
| parent | 3a3d5ba2356b85626d34d6a65e4d8e8e6205b60d (diff) | |
| download | mariadb-git-ae15f91f227015b3e1ad3f566db9396232cf0a3f.tar.gz | |
MDEV-18769 Assertion `fixed == 1' failed in Item_cond_or::val_int
This bug is caused by pushdown from HAVING into WHERE.
It appears because condition that is pushed wasn't fixed.
It is also discovered that condition pushdown from HAVING into
WHERE is done wrong. There is no need to build clones for some
conditions that can be pushed. They can be simply moved from HAVING
into WHERE without cloning.
build_pushable_cond_for_having_pushdown(),
remove_pushed_top_conjuncts_for_having() methods are changed.
It is found that there is no transformation made for fields of
pushed condition.
field_transformer_for_having_pushdown transformer is added.
New tests are added. Some comments are changed.
Diffstat (limited to 'mysql-test/main/having.result')
| -rw-r--r-- | mysql-test/main/having.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/having.result b/mysql-test/main/having.result index dd710db715a..837940a55ef 100644 --- a/mysql-test/main/having.result +++ b/mysql-test/main/having.result @@ -483,7 +483,7 @@ HAVING (table2.f2 = 8); id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Warnings: -Note 1003 select `test`.`table1`.`f1` AS `f1`,7 AS `f2` from `test`.`t1` `table1` join `test`.`t1` `table2` where 0 group by `test`.`table1`.`f1`,7 having multiple equal(8, 7) +Note 1003 select `test`.`table1`.`f1` AS `f1`,7 AS `f2` from `test`.`t1` `table1` join `test`.`t1` `table2` where 0 group by `test`.`table1`.`f1`,7 having 1 DROP TABLE t1; # # Bug#52336 Segfault / crash in 5.1 copy_fields (param=0x9872980) at sql_select.cc:15355 |