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 secur...@mariadb.org _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
