Hi,
I think we might want the "*=" operator treat NULL as not equal to NULL and
this is why we add "IS NOT NULL" to the duplicate detection query.
Your patch treats NULL as equal to NULL, which is different from the SQL
standard, may confuse users.
So I think we should make the "*=" operator treat NULL as not equal to NULL
or add a new operator to implement it. Thoughts?
--
Regards,
ChangAo Chen