[debian-mysql] help with incorrect result with a mariadb server (different versions and currently with 1:10.3.25-0+deb10u1 or 1:10.3.25-0ubuntu1)

[Patrice Duroux]

Hi,

I don't know where to address this.
I have tried to submit a post at maria-discuss
<https://launchpad.net/~maria-discuss> following what is indicated here:
https://mariadb.org/contribute/ but my post never got in without any
notification back and I checked:
https://lists.launchpad.net/maria-discuss/date.html

The structure of the SQL query is:

SELECT id,a,b,c
FROM main
LEFT JOIN (SELECT id,... AS a, ... AS b, ... AS c FROM ...) AS USING (id)

First the result is fine without any WHERE clause.
Then adding a WHERE clause of the form 'WHERE id IN (SELECT ...)',
the columns a,b,c are correct or become all null when it should not be the
case.
It is like suddenly the subquery result in the LEFT JOIN becomes empty.

Suspecting some optimizer troubles, I have also tried to play with the
optimizer_switch variable (even switching almost everything to off) but
without any success.

Same query was working well with MySQL server before Debian switched to
MariaDB.

Thanks,
Patrice
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20201102/242a735c/attachment.html>