MariaDB

  1. Bug #836491
  2. Comment #2

Comment 2 for bug 836491

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

If anybody is wondering why this has not been caught earlier:

In order to hit this bug,
1. parent subquery must use GROUP BY (so that add_ref_to_table_cond is invoked)
2. SJ-Materialization table must be accessed with lookups
3. and it the first non-const table

most of written-to-purpose materialization tests lack #1.