Using CONNECT - Condition Pushdown
MariaDB starting with 10.0.4
Since MariaDB 10.0.4, the CONDITION_PUSHDOWN argument is no longer accepted. However, it is not needed because CONNECT now uses condition pushdown unconditionally.
MariaDB until 10.0.4
If the engine condition pushdown is OFF, it is necessary to set it ON with the optimizer_switch setting, for instance by:
Or launching mysqld with this parameter set to ON, for instance:
mysqld --console --engine_condition_pushdown=on
Note 1: specifying
--console is important to have some error messages from CONNECT printed because MariaDB does not always retrieve them.