[QPID-8104] [Broker-J] [Query] [WMC] Ordering connections tables by port column fails with '422 - The orderBy expression at position '0' is unsupported'

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: qpid-java-broker-7.0.2
• Component/s: Broker-J
• Assignee: Unassigned
• Reporter: Keith Wall
• Created: 20/Feb/18 13:47
• Updated: 02/Oct/19 19:22
• Resolved: 26/Feb/18 16:37

Description

Ordering the connections table on the virtualhost tab by port ends with error 422 - The orderBy expression at position '0' is unsupported.

The select clause in question uses an alias port.name AS port. In general the ability to express an the order by in terms of column aliases is supported however, the issue here seems to be that port is ambiguous and could refer to the Collection#port attribute or the alias.

The user of the query API can workaround by using a column number, or specify the column's expression rather than alias.

I have not looked into this further.