I've been long awaiting the fix of
MDEV-12137 becuase this problem is a blocker in a few use-cases in our application. I've downloaded the latest MariaDB release (10.3.11) and retested our use-case.
To my utmost dissappointment, the problem persists! How can anyone say this problem is fixed, when it's not? Have you actually considered and tested other queries than the one in the issue description?
My use case:
Please do not tell me to rewrite the query (as a workaround) because I can't do that. The query is generated by an ORM framework.
Please, test this use case and fix is as soon as possible.