Jira (PDB-5568) Query failure when ordering by json element

[Austin Blatt (Jira)]

Title: Message Title

Austin Blatt created an issue   PuppetDB / PDB-5568 Query failure when ordering by json element Issue Type: Bug Assignee: Austin Blatt Created: 2023/01/05 10:17 AM Fix Versions: PDB 7.12.0 Priority: Normal Reporter: Austin Blatt Error 2023-01-05 09:20:41,327 ERROR [qtp1721282939-73] [p.p.middleware] #error { :cause ERROR: syntax error at or near "_" Position: 822 :via [{:type org.postgresql.util.PSQLException :message ERROR: syntax error at or near "_" Position: 822 :at [org.postgresql.core.v3.QueryExecutorImpl receiveErrorResponse QueryExecutorImpl.java 2676]}] :trace [[org.postgresql.core.v3.QueryExecutorImpl receiveErrorResponse QueryExecutorImpl.java 2676] Reproduced with curl -X POST http://localhost:8080/pdb/query/v4 \ -H 'Content-Type:application/json' \ -d '{"query": "inventory [facts.os.family] { order by trusted }" }' Add Comment   This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8) -- 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.477993.1672942656000.69970.1672942680194%40Atlassian.JIRA.