On 04/01/2019 10:48, Dominique Devienne wrote:
I was just surprised by this behavior, see below. Googling it, seems like SQL Server has a setting the change the behavior in that case. Is this standard SQL behavior, as implemented in SQLite? Not complaining, just asking whether I can depend on it, or not.
It's standard SQL and plain logic: if you add something unknown to some known stuff, the result is .. unknown, that is, "null". Same with the other SQL scalar expressions (123.4 + null --> null).
JLH _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users