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

15 views
Skip to first unread message

Austin Blatt (Jira)

unread,
Jan 5, 2023, 1:18:01 PM1/5/23
to puppe...@googlegroups.com
Austin Blatt created an issue
 
PuppetDB / Bug PDB-5568
Query failure when ordering by json element
Issue Type: Bug Bug
Assignee: Austin Blatt
Created: 2023/01/05 10:17 AM
Fix Versions: PDB 7.12.0
Priority: Normal 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 Add Comment
 
This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8)
Atlassian logo

Austin Blatt (Jira)

unread,
Jan 5, 2023, 1:23:01 PM1/5/23
to puppe...@googlegroups.com
Austin Blatt updated an issue
Change By: Austin Blatt
Sprint: Skeletor 01/18/2023

Austin Blatt (Jira)

unread,
Jan 5, 2023, 1:33:03 PM1/5/23
to puppe...@googlegroups.com
Austin Blatt updated an issue
Change By: Austin Blatt
Release Notes: Bug Fix

Austin Blatt (Jira)

unread,
Jan 5, 2023, 1:36:03 PM1/5/23
to puppe...@googlegroups.com
Austin Blatt updated an issue
Change By: Austin Blatt
Release Notes Summary: Fix issue where queries ordering by a fact value failed

Austin Blatt (Jira)

unread,
Jan 10, 2023, 11:09:02 AM1/10/23
to puppe...@googlegroups.com
Austin Blatt updated an issue
Change By: Austin Blatt
Fix Version/s: PDB 7.12.1

Austin Blatt (Jira)

unread,
Jan 10, 2023, 11:09:02 AM1/10/23
to puppe...@googlegroups.com
Austin Blatt updated an issue
Change By: Austin Blatt
Affects Version/s: PDB 7.12.0

Austin Blatt (Jira)

unread,
Jan 10, 2023, 11:09:02 AM1/10/23
to puppe...@googlegroups.com
Austin Blatt updated an issue
Change By: Austin Blatt
Fix Version/s: PDB 7.12.0
Reply all
Reply to author
Forward
0 new messages