maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

Hi, Slawomir!

On Aug 13, pslawek83 wrote:
> Hi Guys, is in_predicate_conversion_th going to be re-enabled for
> release builds in some next mariadb release? If I make pull request,
> will you take it?     Basically for everyone not aware about the
> issue, this forced IN-predicate to subquery conversion is
> de-generating some simple queries so badly that they start to take
> couple of hours instead of seconds, and there is currently no way of
> fixing these queries nor to turn this conversion off.
> Thanks,
> Slawomir.

Perhaps instead of in_predicate_conversion_threshold, we'd better add
an optimizer switch to disable this optimization?

I've commented in https://jira.mariadb.org/browse/MDEV-16871

Regards,
Sergei
VP of MariaDB Server Engineering
and security@xxxxxxxxxxx