On May 6, 2012, at 8:18 PM, Luuk wrote: > So, if it is not defined how to sort column b, > how can anyone correctly sort the column a?
While the standard itself might well have nothing helpful to say about how a null value should be sorted by default ( NULLS FIRST or NULLS LAST), a given implementation (e.g. SQLite) will have an opinion about it. That opinion should be consistent. And it appears it's not. Which would qualify as an anomaly. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
