[Firebird-devel] UPDATE OR INSERT and NULLS

[Adriano d. S. F. <adr...@uo...>]

Hi!

A user asked me a question that I think should be discussed here.

Should UPDATE OR INSERT INTO t (N1, N2) VALUES (NULL, 1) MATCHING N1 
check for "N1 = NULL" or "N1 IS NOT DISTINCT FROM NULL"?

It's now checking with equal, so the statement above executed more than 
one time always insert records.

Opinions?


Adriano