Mariadb Issues

[cloudrck]

As per my previous bug report, I have finally gotten around to filling a bug report with MariaDB.

 

They are pretty fast in dealing with reports, so it's making some progress. And I thought I would post what one of the developers said about Blesta's handling of this specific query.

 

https://mariadb.atlassian.net/browse/MDEV-5049

 

I'm going to try the dev's suggestion today when I get time and see what happens.

[cloudrck]

I can verify that the suggestion by the dev to set works

 

 

set global optimizer_switch='derived_merge=off,derived_with_keys=off';
set optimizer_switch='derived_merge=off,derived_with_keys=off';

But this isn't the ideal method and there needs to be a change in the query itself. Doesn't seem like a bug with MariaDB as we once thought

[Cody]

Discussion continued in your original Bug Report.