Timeline for Inconsistent result when running same query on slightly distinct MariaDB versions
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 28, 2023 at 6:54 | comment | added | danblack | on this source, I've tested 10.4.32 (latest) which returned no result. I've checked multiple 10.5 version include 10.5.19+ (every increment) and 10.5.15 and all latest release of 10.6, 10.10, 10.11, 11.0, 11.1, 11.2, 11.3-rc and all return the 5 row result. | |
| Nov 22, 2023 at 19:58 | comment | added | Rick James |
Did you check that the subquery also returned (21,14,11,10) on 10.11.4? Please provide EXPLAIN SELECT ... for both servers.
|
|
| Nov 22, 2023 at 13:15 | comment | added | joanq | Yes, the results are 21,14,11,10,10, 6, 5, 4... The two tens can get swapped, but this doesn't change the result. Anyway, even if sorting by rand(), the query should return at least 4 rows, because the counting in the main query and the subquery is the same. | |
| Nov 22, 2023 at 11:34 | comment | added | Akina |
Are you sure that ORDER BY COUNT(a2.AlbumId) DESC provides deterministic sorting? Does COUNT(a2.AlbumId) is really unique, and there are no 2 separate rows with the same count? If not then the sorting is not deterministic, and the output provided by LIMIT is unpredictable.
|
|
| Nov 22, 2023 at 11:15 | history | edited | joanq | CC BY-SA 4.0 |
added 171 characters in body
|
| Nov 22, 2023 at 10:59 | history | edited | joanq | CC BY-SA 4.0 |
added 92 characters in body
|
| S Nov 22, 2023 at 10:23 | review | First questions | |||
| Nov 22, 2023 at 10:54 | |||||
| S Nov 22, 2023 at 10:23 | history | asked | joanq | CC BY-SA 4.0 |