Jira (PDB-5136) Inventory endpoint regular expression match matches structures

[Jonathan Newman (Jira)]

Jonathan Newman created an issue

PuppetDB / PDB-5136 Inventory endpoint regular expression match matches structures Issue Type: Bug Assignee: Unassigned Created: 2021/05/24 1:49 PM Priority: Normal Reporter: Jonathan Newman If the regular expression match for the inventory endpoint is applied to a fact that is not a leaf, the underlying regular expression is applied to the JSON equivalent of that content. For example: inventory[certname] { facts.memory ~ "\"" } Matches the quotes in the json. Add Comment

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

[Austin Boyd (Jira)]

Austin Boyd updated an issue

PuppetDB / PDB-5136 Inventory endpoint regular expression match matches structures

Change By: Austin Boyd Zendesk Ticket Count: 1 Zendesk Ticket IDs: 44407

Add Comment

[Austin Boyd (Jira)]

Austin Boyd updated an issue

PuppetDB / PDB-5136 Inventory endpoint regular expression match matches structures

Change By: Austin Boyd Labels: jira_escalated

Add Comment

[Margaret Lee (Jira)]

Margaret Lee commented on PDB-5136

Re: Inventory endpoint regular expression match matches structures Carl Caum FYI - this came out of a Fannie Mae escalation. The team thinks this will help with the issue FM is seeing. Jonathan is also looking into other improvements in addition to this. I think this could be good to do to prevent another future escalation.

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5136

Inventory endpoint regular expression match matches structures

Change By: Bogdan Irimie Team: Ghost

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5136 Inventory endpoint regular expression match matches structures

Change By: Bogdan Irimie Sprint: ghost-22.09.2021

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie commented on PDB-5136

Re: Inventory endpoint regular expression match matches structures If we expose `jsonb_typeof` we should add documentation for it.

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5136

Inventory endpoint regular expression match matches structures

Change By: Bogdan Irimie Story Points: 3

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie commented on PDB-5136

Re: Inventory endpoint regular expression match matches structures Spoke with Austin Blatt and he provided some examples {"foo": "bar"}. node1 {"foo": {"bar": "baz"} node2 and the query could be inventory[] { facts.foo ~ "bar" and jsonb_typeof("facts.foo") = "string" } If such a query would work, we would be able to select only node 1.

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie commented on PDB-5136

Re: Inventory endpoint regular expression match matches structures

The `jsonb_typeof` function might already be used internally: https://github.com/puppetlabs/puppetdb/blob/main/src/puppetlabs/puppetdb/query_eng/engine.clj#L210-L217

Add Comment

[Oana Tanasoiu (Jira)]

Oana Tanasoiu assigned an issue to Oana Tanasoiu

PuppetDB / PDB-5136

Inventory endpoint regular expression match matches structures

Change By: Oana Tanasoiu Assignee: Oana Tanasoiu

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5136 Inventory endpoint regular expression match matches structures

Change By: Bogdan Irimie Sprint: ghost-22.09.2021 , ghost-6.10.2021

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5136 Inventory endpoint regular expression match matches structures

Change By: Bogdan Irimie Sprint: ghost-22.09.2021, ghost-6.10.2021 , ghost-20.10.2022

Add Comment

[Bogdan Irimie (Jira)]