Cannot retrive null values

SQL++
1

SELECT * FROM catalog WHERE status = “pending_debtor_id” AND address_proof_status = “admin_approved” AND payment_status =“admin_approved” AND table_type = “b2b_reseller” UNION
SELECT * FROM catalog WHERE status = “pending_debtor_id” AND address_proof_status = null AND payment_status =“admin_approved” AND table_type = “b2b_reseller” UNION
SELECT * FROM catalog WHERE status = “pending_debtor_id” AND tax_proof_status = “admin_approved” AND payment_status =“admin_approved” AND table_type = “b2b_reseller” UNION
SELECT * FROM catalog WHERE status = “pending_debtor_id” AND tax_proof_status = null AND payment_status =“admin_approved” AND table_type = “b2b_reseller” ;

i cannot retrieve the data which values are null.

2

NULL/MISSING are undefined and when you compared using relation operators it always returns false because undefined can’t be compared.

If you need to compare those we have (x IS NULL, x IS MISSING, x IS NOT NULL, x IS NOT MISSING ). https://docs.couchbase.com/server/6.0/n1ql/n1ql-language-reference/comparisonops.html

SELECT * FROM default WHERE address_proof_status IS NULL;