MariaDB

  1. Bug #869036
  2. Comment #2

Comment 2 for bug 869036

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

There is a partial match between the outer row (NULL, 'c') and the inner row ('v', null).
Therefore the correct result of the IN predicate is NULL, and the strategy that produces
an incorrect result is partial_match_rowid_merge.