Jira (PDB-5262) Grouping by facts that contain "/" generates invalid SQL

[Sebastian Miclea (Jira)]

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 Endpoint:http://localhost:8080/pdb/query/v4/inventory GROUP BY statement contains only what is after "/". Add Comment

This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97)

[Bogdan Irimie (Jira)]

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

[Bogdan Irimie (Jira)]

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

[Bogdan Irimie (Jira)]

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

[Sebastian Miclea (Jira)]

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