MySQL Forums
Forum List  »  Newbie

Re: strange observation with "order by"
Posted by: Alex Yanovsky
Date: October 25, 2018 11:29AM

This is my create table statement:

create table testsimple (
a varchar(10)
);

These are my inserts:

insert into testsimple values ('abc');

insert into testsimple values ('def');


That's it, the rest is a query I posted originally, with and without order by giving different result

I first saw it with my real more complex query, but then made this very simple one and it shows the same issue.

I initially thought it was again my old version of MySQLShell whhich caused some issues before, so I installed MySQLShell 8.0.13 from Oracle web site, but the issue still persists.

Options: ReplyQuote


Subject
Written By
Posted
Re: strange observation with "order by"
October 25, 2018 11:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.