MariaDB [test]> select version();

+----------------+

| version()      |

+----------------+

| 10.2.2-MariaDB |

+----------------+

1 row in set (0.00 sec)

MariaDB [test]> SET  sql_mode = 'ONLY_FULL_GROUP_BY';

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> explain extended SELECT * FROM t1 

    ->   LEFT OUTER JOIN 

    ->   (SELECT id2, COUNT(*) as ct FROM t2 GROUP BY id2) vc USING (id2)

    -> WHERE (vc.ct>0);

ERROR 1463 (42000): Non-grouping field 'ct' is used in HAVING clause

MariaDB [test]> SET optimizer_switch='condition_pushdown_for_derived=off';

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> explain extended SELECT * FROM t1 

    ->   LEFT OUTER JOIN 

    ->   (SELECT id2, COUNT(*) as ct FROM t2 GROUP BY id2) vc USING (id2)

    -> WHERE (vc.ct>0);

+------+-------------+------------+------+---------------+------+---------+-------------+------+----------+---------------------------------+

| id   | select_type | table      | type | possible_keys | key  | key_len | ref         | rows | filtered | Extra                           |

+------+-------------+------------+------+---------------+------+---------+-------------+------+----------+---------------------------------+

|    1 | PRIMARY     | t1         | ALL  | NULL          | NULL | NULL    | NULL        |    8 |   100.00 | Using where                     |

|    1 | PRIMARY     | <derived2> | ref  | key0          | key0 | 5       | test.t1.id2 |    2 |   100.00 | Using where                     |

|    2 | DERIVED     | t2         | ALL  | NULL          | NULL | NULL    | NULL        |    6 |   100.00 | Using temporary; Using filesort |

+------+-------------+------------+------+---------------+------+---------+-------------+------+----------+---------------------------------+

3 rows in set, 1 warning (0.00 sec)