On Tue, Mar 23, 2021 at 6:45 PM Marc Millas <marc(dot)millas(at)mokadb(dot)com> wrote:
> So.. I would like to understand the "why" of this behaviour, ie. the
> change of order when I do the cast.
>
I believe the "why" is immaterial here. Your queries do not contain order
by so your results are unordered - even if there appears to be an apparent
ordering for any particular result.
David J.