MariaDB

  1. Bug #994392
  2. Comment #2

Comment 2 for bug 994392

Revision history for this message
Oleksandr "Sanja" Byelkin (sanja-byelkin) wrote : Re: Wrong result with RIGHT JOIN and ALL subquery predicate in WHERE condition

The bug repeatable also for LEFT join (also table should change order).

Cause of the bug is incorrect not_null_tables of Item_func_not_all (it makes optimizer thinks that the function will reject NULLs).