On May 6, 2012, at 8:34 PM, Simon Slavin wrote: > I'm not sure about a requirement for consistency. NULL isn't a value. It > means something like 'value unknown'. Anything attempting to sort columns > with nulls in can sort any of the nulls into any position.
Well, as pointed out by Yuriy and Pavel, it's a bug due to SQLite trying to take a shortcut by assuming unique keys are already properly sorted, but not accounting for the presence of nulls in such index: http://www.sqlite.org/src/info/2a5629202f _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
