Public bug reported: The Focal-shipped MariaDB 10.3.22 is affected by: https://jira.mariadb.org/browse/MDEV-21614
It is fixed in 10.3.23, and it was apparently not broken in 10.3.21. It's a nasty optimizer bug that makes certain expressions like this wrongly return no results: SELECT y FROM y WHERE y.id IN (SELECT y.id FROM y WHERE ...) The release notes say: https://mariadb.com/kb/en/mariadb-10323-release-notes/ "Optimizer, Wrong query results with optimizer_switch="split_materialized=on" (MDEV-21614)" Tracking the problem down to this was rather time consuming. I wish for others to make better use of their time, and I hope a fix gets included into Focal soon. A temporary workaround is to set SET optimizer_switch="split_materialized=off"; Cheers, Walter Doekes OSSO B.V. ** Affects: mariadb-10.3 (Ubuntu) Importance: Undecided Status: New ** Tags: focal -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1894855 Title: MariaDB 10.3.22-MariaDB-1ubuntu1 on Focal has subquery optimizer bug To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.3/+bug/1894855/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs