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+limit return results, some data is missing #5223

Closed
QingZ11 opened this issue Jan 9, 2023 · 0 comments · Fixed by #5241
Closed

skip+limit return results, some data is missing #5223

QingZ11 opened this issue Jan 9, 2023 · 0 comments · Fixed by #5241
Assignees
Labels
affects/none PR/issue: this bug affects none version. process/done Process of bug severity/none Severity of bug type/bug Type: something is unexpected
Milestone

Comments

@QingZ11
Copy link
Contributor

QingZ11 commented Jan 9, 2023

  • NebulaGraph version is v3.3

When using the official basketballplayer data set + skip + limit in Cypher to do data pagination, I found a weird rule. As long as the number of skip is less than / equal to one-half of the limit, there will be data loss, which is less than one-third After about one hour, all data is lost:

image

image

image

image

statements as below:

(root@nebula) [basketballplayer]> match  ()-[e]->() return e  skip 100 limit 34
+-----------------------------------------------------------------------+
| e                                                                     |
+-----------------------------------------------------------------------+
| [:follow "player109"->"player125" @0 {degree: 90}]                    |
| [:serve "player111"->"team200" @0 {end_year: 2018, start_year: 2016}] |
+-----------------------------------------------------------------------+
Got 2 rows (time spent 12.682ms/20.443416ms)

Mon, 09 Jan 2023 06:48:09 UTC

(root@nebula) [basketballplayer]> match  ()-[e]->() return e  skip 100 limit 3
+---+
| e |
+---+
+---+
Empty set (time spent 7.91ms/8.722916ms)

Mon, 09 Jan 2023 06:48:23 UTC

(root@nebula) [basketballplayer]> match  ()-[e]->() return e  skip 100 limit 30
+---+
| e |
+---+
+---+
Empty set (time spent 24.068ms/31.6455ms)

Mon, 09 Jan 2023 06:49:42 UTC

ref: https://discuss.nebula-graph.com.cn/t/topic/11863

@QingZ11 QingZ11 added the type/bug Type: something is unexpected label Jan 9, 2023
@github-actions github-actions bot added affects/none PR/issue: this bug affects none version. severity/none Severity of bug labels Jan 9, 2023
@Sophie-Xie Sophie-Xie added this to the v3.4.0 milestone Jan 10, 2023
@github-actions github-actions bot added the process/fixed Process of bug label Jan 12, 2023
@Hester-Gu Hester-Gu added the process/done Process of bug label Jan 13, 2023
@github-actions github-actions bot removed the process/fixed Process of bug label Jan 13, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects/none PR/issue: this bug affects none version. process/done Process of bug severity/none Severity of bug type/bug Type: something is unexpected
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants