Jira (PDB-5350) puppet-query for null fact returns empty set

[Hugh Brown (Jira)]

Title: Message Title

Hugh Brown created an issue   PuppetDB / PDB-5350 puppet-query for null fact returns empty set Issue Type: Bug Assignee: Unassigned Components: PuppetDB Created: 2021/10/27 4:26 PM Priority: Low Reporter: Hugh Brown Puppet Version: 6.24.0 Puppet Server Version: PE 2019.8.8 OS Name/Version: Fedora 33 I'm running puppet-query to get a list of systems that do not have a fact set `puppet-query inventory[certname] { facts.my_external_fact is null }` and it returns an empty set. If I switch to: `puppet-query inventory[certname] { facts.my_external_fact is not null }` it returns the list of systems that have the fact defined. Describe steps to reproduce: Create an external fact on a subset of systems on a primary server. Query puppetdb using puppet-query for systems for which the fact is null. Desired Behavior: The number of systems returned by `facts.my_external_fact is not null ` and `facts.my_external_fact is null` should total up to all systems. Actual Behavior: The query for `facts.my_external_fact is null ` returns an empty set   Add Comment   This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.421378.1635377172000.165078.1635377220079%40Atlassian.JIRA.