maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #05902
Re: MariaDB 10.4: subtle change of result ordering
Hi, Reindl!
Sorry, I couldn't understand, was 10.3 returning 3..2..1 and 10.4
started to return 1..2..3? Or was it the other way around?
I tried your table structure and your test data on both 10.3 and 10.5
and in both cases I've got 3..2..1
On Aug 21, Reindl Harald wrote:
>
> in all previous versions this test was stable, so as the timestamps are
> identical and ordering is 'desc' the result was ordered by the creation
> time of the the records
...
> diff of the expected application output:
>
> -<html><head><title>Autotest</title></head><body><a
> name="commentpart"></a><div><a
> href="comments_add.php?s2id=1">Verfassen</a><table><tr><td>CMS-Autotest
> 1</td><td></td></tr><tr><td colspan="2">Test Test Test Test Test Test
> Test Test Test Test</td></tr></table><table><tr><td>CMS-Autotest
> 2</td><td></td></tr><tr><td colspan="2">Test Test Test Test Test Test
> Test Test Test Test</td></tr></table><table><tr><td>CMS-Autotest
> 3</td><td></td></tr><tr><td colspan="2">Test Test Test Test Test Test
> Test Test Test
> Test</td></tr></table><table><tr><td></td><td></td></tr></table></div></body>
>
> +<html><head><title>Autotest</title></head><body><a
> name="commentpart"></a><div><a
> href="comments_add.php?s2id=1">Verfassen</a><table><tr><td>CMS-Autotest
> 3</td><td></td></tr><tr><td colspan="2">Test Test Test Test Test Test
> Test Test Test Test</td></tr></table><table><tr><td>CMS-Autotest
> 2</td><td></td></tr><tr><td colspan="2">Test Test Test Test Test Test
> Test Test Test Test</td></tr></table><table><tr><td>CMS-Autotest
> 1</td><td></td></tr><tr><td colspan="2">Test Test Test Test Test Test
> Test Test Test
> Test</td></tr></table><table><tr><td></td><td></td></tr></table></div></body>
>
Regards,
Sergei
VP of MariaDB Server Engineering
and security@xxxxxxxxxxx
Follow ups
References
