IS DISTINCT FROM / IS NOT DISTINCT FROM

(1) By Vif Ardente (vif_ardente) on 2022-06-24 19:35:35 [source]

Please implement IS DISTINCT FROM / IS NOT DISTINCT FROM. It is often usefull for queries with parameters (eg select * from detail where master_id is not distinct from @master_id)

(2) By Richard Hipp (drh) on 2022-06-24 19:38:37 in reply to 1 [link] [source]

See item 2 on the version 3.39.0 draft change log.

Note also that SQLite has long supported the "IS" operator, which means the same thing as "IS NOT DISTINCT FROM" and the "IS NOT" operator which is the same as "IS DISTINCT FROM".

(3) By Vif Ardente (vif_ardente) on 2022-06-25 07:03:20 in reply to 2 [link] [source]

Excellent! Thank you for quick and useful reply.