maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #05903
Re: MariaDB 10.4: subtle change of result ordering
Am 24.08.20 um 14:23 schrieb Sergei Golubchik:
> 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?
that at a bottom is a unified iff between expected output and what
happens when trying 10.4.14
10.2 and 10.3 returning 1-2-3 for years
10.4.14 in the identical environemnt returns 3-2-1
* they are created 1-2-3
* timestamps identical because created in same second
* 'desc' ordering by timestamp gave 1-2-3
my issue is not that the result as such could be called wrong but that
it changes after years, the autotests which is part of a bug testsuite
has the expected HTML output base64 decoded, fires a diff against the
now created html-output and alerts if there is a byte changed
> 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>
Follow ups
References
