I'm not sure if this is the right list to discuss this, but, I have a
suggestion:
ORDER BY clause, as defined in the SELECT documentation says:
"If ORDER BY is not given, the rows are returned in whatever order the system
finds fastest to produce"
This order is usually not wanted, as it is not predictable. I believe many
people would expect the order of rowsreturned in this case, to be ordered as
the primary key of the table, or the same order the rows were inserted.
I suggest to change this behavior. If one makes a SELECT statement without any
ORDER BY, it would beclever to automatically sort by the first primary key
found in the query, if any.The present behavior would still be used in case of
queries without any primary key fields.
This would save a lot of repeated clauses "ORDER BY <table primary key>" that
we have to add to every SELECT, even the most simple one"SELECT * FROM
<table>"If we actually want the order of the rows to make any sense.
