Jira (PDB-5262) Grouping by facts that contain "/" generates invalid SQL
Title: Message Title Sebastian Miclea assigned an issue to Sebastian Miclea PuppetDB / PDB-5262 Grouping by facts that contain "/" generates invalid SQL Change By: Sebastian Miclea Assignee: Sebastian Miclea 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.415600.1631630062000.140663.1632812100188%40Atlassian.JIRA.
Jira (PDB-5262) Grouping by facts that contain "/" generates invalid SQL
Title: Message Title Bogdan Irimie updated an issue PuppetDB / PDB-5262 Grouping by facts that contain "/" generates invalid SQL Change By: Bogdan Irimie Story Points: 1 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.415600.1631630062000.136149.1632297720041%40Atlassian.JIRA.
Jira (PDB-5262) Grouping by facts that contain "/" generates invalid SQL
Title: Message Title Bogdan Irimie updated an issue PuppetDB / PDB-5262 Grouping by facts that contain "/" generates invalid SQL Change By: Bogdan Irimie Sprint: ghost-6.10.2021 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.415600.1631630062000.136148.1632297660030%40Atlassian.JIRA.
Jira (PDB-5262) Grouping by facts that contain "/" generates invalid SQL
Title: Message Title Bogdan Irimie commented on PDB-5262 Re: Grouping by facts that contain "/" generates invalid SQL We should check if it works with https://github.com/puppetlabs/puppetdb/pull/3573 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.415600.1631630062000.136146.1632297600277%40Atlassian.JIRA.
Jira (PDB-5262) Grouping by facts that contain "/" generates invalid SQL
Title: Message Title Sebastian Miclea created an issue PuppetDB / PDB-5262 Grouping by facts that contain "/" generates invalid SQL Issue Type: Bug Assignee: Unassigned Created: 2021/09/14 7:34 AM Priority: Normal Reporter: Sebastian Miclea Example query: ["extract",[["function", "count"], "facts.partitions.\/.size"], ["group_by", "facts.partitions.\/.size"]] Result: Unterminated identifier started at position 699 in SQL WITH inactive_nodes AS (SELECT certname FROM certnames WHERE (deactivated IS NOT NULL AND deactivated > '2021-08-31T14:29:44.254Z') OR (expired IS NOT NULL and expired > '2021-08-31T14:29:44.254Z')), not_active_nodes AS (SELECT certname FROM certnames WHERE (deactivated IS NOT NULL OR expired IS NOT NULL)) SELECT (fs.stable||fs.volatile)->'partitions'->'/'->'size' AS "facts.partitions./.size", count(*) count FROM factsets fs LEFT JOIN environments ON fs.environment_id = environments.id LEFT JOIN certnames ON fs.certname = certnames.certname WHERE NOT ((certnames.certname) in (SELECT certname FROM ( SELECT not_active_nodes.certname AS "certname" FROM not_active_nodes ) sub)) GROUP BY .size". Expected " char
