Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SKIP with ORDER BY fails when direction is not specified #1743

Closed
odbuser2 opened this issue Oct 17, 2013 · 0 comments
Closed

SKIP with ORDER BY fails when direction is not specified #1743

odbuser2 opened this issue Oct 17, 2013 · 0 comments
Assignees
Milestone

Comments

@odbuser2
Copy link

orientdb-1.6.0-SNAPSHOT (within a few days)

The following query:
select from V order by x SKIP 5 LIMIT 10

Results in:
com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #32: Ordering mode 'SKIP' not supported. Valid is 'ASC', 'DESC' or nothing ('ASC' by default)
Command: select from V order by x SKIP 5 LIMIT 10

However, the following queries all work:
select from V order by x LIMIT 10
select from V order by x LIMIT 10 SKIP 5
select from V order by x ASC SKIP 5 LIMIT 10

It is a syntax parsing issue with the location of SKIP. Oddly enough, LIMIT can follow an order by without the direction specified.

@ghost ghost assigned lvca Oct 17, 2013
lvca added a commit that referenced this issue Oct 17, 2013
@lvca lvca closed this as completed Oct 17, 2013
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

2 participants