MariaDB

  1. Bug #702345
  2. Comment #1

Comment 1 for bug 702345

Revision history for this message
Timour Katchaounov (timour) wrote :

The bug is present both with MATERIALIZATION and with IN-TO-EXISTS,
but not with SEMIJOIN:
set @@optimizer_switch='materialization=on,in_to_exists=on,semijoin=off';
set @@optimizer_switch='materialization=off,in_to_exists=on,semijoin=off';
set @@optimizer_switch='materialization=on,in_to_exists=off,semijoin=off';