‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Friday, August 21, 2020 12:18 PM, Reindl Harald <h.rei...@thelounge.net> wrote:
> MyISAM: > > 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 > > now it's reverse which can break all sort of expectations in subtle ways > > while we could discuss what is the expected output when order by > 'ktimestamp' and all are identical it still worries me that something > which didn't change over years and major versions now comes with the > reverse ordering > > unless someone tells me that's the result of some real peformance > optimization i would perfer the known result given that it's hard to > know how much other code depends implicit on the previous behavior I would say that the actual ordering of the records below obtained by the select command shown is undefined. I can very well change for whatever subtle change in code. AFAIU, if you need repeatable results, you need to write a select command with a deterministic result. If this test has been presenting repeatable results for a long time, that's just chance. But that's just the opinion of a MariaDB user. I'm no developer. I would like to know the opinion of the developers. Regards, Rodrigo Severo _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
