MariaDB

  1. Bug #904345
  2. Comment #1

Comment 1 for bug 904345

Revision history for this message
Elena Stepanova (elenst) wrote : Re: Wrong empty result instead of NULL for MAX/MIN with derived_merge=ON

As Igor pointed out, the problem is reproducible without a derived table, with a view:

CREATE TABLE t1 ( a int(11) NOT NULL, KEY(a) );
INSERT INTO t1 VALUES (10),(11);
CREATE VIEW v AS SELECT * FROM t1;

SELECT MAX(a) FROM v WHERE (1,2) IN ( SELECT 3,4 );

Reproducible on 5.2.10 and 5.1.60, and on MySQL 5.1.60.