MariaDB

  1. Bug #777691
  2. Comment #1

Comment 1 for bug 777691

Revision history for this message
Philip Stoev (pstoev-askmonty) wrote :

Another test case:

SET @@optimizer_switch='materialization=off,subquery_cache=off,semijoin=off';

CREATE TABLE t1 ( f11 varchar(32)) ;
INSERT IGNORE INTO t1 VALUES ('x'),('b');

CREATE TABLE t2 ( f2 int, f10 varchar(32)) ;
INSERT IGNORE INTO t2 VALUES (1,'x');

SELECT ( SELECT MAX( f2 ) FROM t2 WHERE t2.f10 <> t1.f11 ) FROM t1;