On 12/3/2013 17:29, James K. Lowden wrote:
Determinism is a property of a function; there is no such thing as a function that is sometimes deterministic and sometimes not.
Unless you're new to this computing thing, you must have noticed that software developers almost never mean the same thing as mathematicians when we use the word "function".
There are tiny corners of the programming world (FP) where this is not the case, but then you get into questions of purity, and databases are about as far from side-effect-free as you can get.
Anyway, all this arguing over how SQLite *should* behave seems misguided to me. What matters is how SQL is specified. SQLite should follow the spec in areas like this.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
