Jira (PDB-3591) Limit on inner query seems to affect outer query

[Scott Walker (JIRA)]

Title: Message Title

Scott Walker created an issue   PuppetDB / PDB-3591 Limit on inner query seems to affect outer query Issue Type: Bug Assignee: Unassigned Components: PuppetDB Created: 2017/06/23 5:51 AM Priority: Major Reporter: Scott Walker Initially, query this: [:from :packages [:extract [:package_name :provider] [:group_by :package_name :provider]] [:limit 10] [:offset 0] [:order_by [:package_name :provider]]]   => [({:package_name "CFPropertyList", :provider "gem"} {:package_name "GConf2", :provider "yum"} {:package_name "PyYAML", :provider "pip"} {:package_name "PyYAML", :provider "yum"} {:package_name "SOAPpy", :provider "pip"} {:package_name "SecretStorage", :provider "pip"} {:package_name "acl", :provider "apt"} {:package_name "acl", :provider "yum"} {:package_name "acpi", :provider "apt"} {:package_name "activesupport", :provider "gem"}) nil] That gives me the first 10 packages excluding version. Now I want to get all versions of those packages. I'm expected more than 10 results this time: [:from :packages [:extract [:package_name :provider :version] [:in [:package_name :provider] [:from :packages [:extract [:package_name :provider] [:group_by :package_name :provider]] [:limit 10] [:offset 0] [:order_by [:package_name :provider]]]]]]   => [({:package_name "acl", :provider "apt", :version "2.2.52-3"} {:package_name "SOAPpy", :provider "pip", :version "0.12.22"} {:package_name "acl", :provider "yum", :version "2.2.51-12.el7"} {:package_name "SecretStorage", :provider "pip", :version "2.3.1"} {:package_name "GConf2", :provider "yum", :version "3.2.6-8.el7"} {:package_name "PyYAML", :provider "pip", :version "3.12"} {:package_name "CFPropertyList", :provider "gem", :version "2.2.8"} {:package_name "CFPropertyList", :provider "gem", :version "2.3.5"} {:package_name "acpi", :provider "apt", :version "1.7-1"} {:package_name "PyYAML", :provider "yum", :version "3.10-11.el7"}) nil] 10 results again. See how "activesupport" has dropped off the list? We're actually trying to change the Package page to aggregate on name/provider rather than name/version/provider but seeing the same issue, with a query something like this: [:from :package_inventory [:extract [:package_name :provider [:function :count]] [:and [:= [:node :active] :true] [:in [:package_name :provider] [:from :packages [:extract [:package_name :provider] ["~" :package_name filter]] [:order_by [:package_name :provider]] [:limit limit] [:offset offset]]]] [:group_by :package_name :provider]] [:order_by [:package_name :provider]]] Add Comment   This message was sent by Atlassian JIRA (v6.4.14#64029-sha1:ae256fe) -- 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.