[DM-2860] Add support for ORDER BY expressions - Jira

XML

Word

Printable

Details

Type: Story
Status: To Do
Resolution: Unresolved
Fix Version/s: None
Component/s: None
Labels:
None

Epic Link:
Qserv Query Coverage
Team:
Data Access and Database
Urgent?:
No

Description

Parser doesn't support function in ORDER BY clause:

 order by ABS(taiMidPoint)

SELECT objectId, taiMidPoint FROM Source order by ABS(taiMidPoint) ASC

ERROR 4110 (Proxy) at line 1: Qserv error: 'ParseException:Parse error(ANTLR):unexpected token: (:'

Attachments

Issue Links

relates to

DM-2859 Return error for "SELECT a FROM T ORDER BY b" for has-chunks query

To Do

DM-2894 Study how to solve "ORDER BY FUNC(field)"

To Do

mentioned in: Page Loading...

Activity

Hide

Permalink

Jacek Becla added a comment - 02/Jun/15 8:08 AM

Fabrice, this is quite difficult to implement in a generic way, I talked with Daniel about it in the past. We already well documented that it doe snot work. I'd recommend to not attempt to address it right now.

Show

Jacek Becla added a comment - 02/Jun/15 8:08 AM Fabrice, this is quite difficult to implement in a generic way, I talked with Daniel about it in the past. We already well documented that it doe snot work. I'd recommend to not attempt to address it right now.

People

Assignee:: Fritz Mueller

Reporter:: Fabrice Jammes

Watchers:

Votes:: 0 Vote for this issue

Watchers:: 0 Start watching this issue

Dates

Created:: 02/Jun/15 6:44 AM

Updated:: 22/Jun/22 10:10 PM

Jenkins

No builds found.

Data Management