MP sqlite registry foreign keys

[Bradley Giesbrecht]

The MacPorts registry.db table "dependencies" has a foreign key column "id" referencing ports.id.

How can this query not be empty?

SELECT dependencies.*
FROM dependencies
LEFT JOIN ports ON dependencies.id = ports.id
WHERE ports.id IS null;

With this query I get result rows so I have records in my "dependencies" table with a dependencies.id value that DOES NOT match any ports.id value.


Regards,
Bradley Giesbrecht (pixilla)