Am 03.10.19 um 11:41 schrieb Thomas Plant:
Client did some tests and he discovered that the following query will crash reliably:
SELECT * FROM `users` WHERE ( `role` = 1 OR `role` = 10 ) AND EXISTS ( SELECT * FROM `email_templates` INNER JOIN `users_email` ON `email_templates`.`id` = `users_email`.`email_template_id` WHERE `users`.`id` = `users_email`.`user_id` AND `email_template_id` = 12 ) AND `users`.`deleted_at` IS NULL;
Strange thing is when he changes the `email_template_id` = 12 to `email_template_id` = 11 (or any other value) the query works.
I checked with "mysqlcheck -ce dbname" and no error resulted
Installed MariaDB 10.3 and the query gives no problems. So is this a 10.4 bug?
obviously and given that "10.4.6 Stable 2019-06-18" was the first GA release nobody right in his mind is using 10.4 that early in production, even Fedora 32 (Rawhide) is still on 10.3.x we upgraded recently to 10.3 and not earlier for good reasons P.S.: there is no need for a full quote and include dozens of list footers for a single line reply