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 command not working with EXPAND - IN sql construct #8389

Closed
andrea-tomassi opened this issue Jul 10, 2018 · 0 comments
Closed

SKIP command not working with EXPAND - IN sql construct #8389

andrea-tomassi opened this issue Jul 10, 2018 · 0 comments

Comments

@andrea-tomassi
Copy link

andrea-tomassi commented Jul 10, 2018

OrientDB Version: 2.2.33
Java Version: openjdk 1.8
OS: alpine 3.4

Expected behavior

select expand(inE('MyEdge')) from MyVertex where @Rid="#x:y" order by @Rid SKIP 1 LIMIT 1
should return the first element

select expand(inE('MyEdge')) from MyVertex where @Rid="#x:y" order by @Rid SKIP 10 LIMIT 1
should return the 11° element

Actual behavior

select expand(inE('MyEdge')) from MyVertex where @Rid="#x:y" order by @Rid SKIP 1 LIMIT 1
returns the first element

select expand(inE('MyEdge')) from MyVertex where @Rid="#x:y" order by @Rid SKIP 10 LIMIT 1
returns the first element, too.

SKIP clause is not working at all

Steps to reproduce

MyEdge is an Edge enterting into MyVertex
#x:y in an existing @Rid for MyVertex
select expand(inE('MyEdge')) from MyVertex where @Rid="#86:0" order by @Rid SKIP 1 LIMIT 1
then:
select expand(inE('MyEdge')) from MyVertex where @Rid="#86:0" order by @Rid SKIP 10 LIMIT 1

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