MariaDB

  1. Bug #823930
  2. Comment #2

Comment 2 for bug 823930

Revision history for this message
Sergey Petrunia (sergefp) wrote :

Looking at EXPLAIN outputs, I see that

- The query with "Correct result" settings does not use Materialization (even though optimizer_switch value instructs it to do it)

- The query with "Wrong result" settings does use Materialization.

It seems, the problem is that SJ-Materialization attempts to handle this case, while it should refuse it, like regular materialization did.