On Thu, Aug 15, 2013 at 1:12 AM, Peter Aronson <pbaron...@att.net> wrote:
> While I can certainly see the value of going with what PostgreSQL and SQL > Server do on the ORDER BY issue, I have to say that I suspect that Oracle's > behavior here seem more in line Principle of Least Astonishment. Another factor to consider here is "expected portability": it is much more often to see apps which support sqlite/mysql/postgres combination than an sqlite/oracle combination. Even if Oracle may have the least surprising behaviour, it's likely that most sqlite users who have used other DBs, have used one of the OSS DBs, and would likely be more surprised by Oracle's behaviour. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
