subject:"\[sqlite\] Concatenating text literals with NULL yields NULL"

Re: [sqlite] Concatenating text literals with NULL yields NULL

2019-01-04 Thread Jean-Luc Hainaut

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

[sqlite] Concatenating text literals with NULL yields NULL

2019-01-04 Thread Dominique Devienne

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. Thanks, --DD