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

数据查询失败: 数据查询失败Scan vertices or edges need to specify a limit number, or limit number can not push down. #65

Closed
Bingai077 opened this issue Oct 25, 2022 · 9 comments

Comments

@Bingai077
Copy link

demo项目测试用例跑不通,selectByIds方法实现有问题
image
执行结果:
image

@CorvusYe
Copy link
Collaborator

方便提供下NebulaGraph版本跟Schema吗

@CorvusYe
Copy link
Collaborator

可能是少索引了

CREATE TAG INDEX `person_idx` on `person`() 

@Bingai077
Copy link
Author

是索引少了,加了索引就好了,谢谢

@wey-gu
Copy link
Member

wey-gu commented Oct 25, 2022

奇怪,请问 @Bingai077 你在用什么版本的 NebulaGraph? 可以给执行一下

explain match(n:person) where id(n) IN  ["foo", "bar"] return n

么?这个查询按理说不需要索引的

@wey-gu
Copy link
Member

wey-gu commented Oct 25, 2022

感谢 @CorvusYe 帮忙试出来这个问题是在用 cypher param 的时候触发的,这是数据库的 bug,正常这个情况下是不需要创建索引的,非常抱歉。

参考 vesoft-inc/nebula#4781

@wey-gu wey-gu closed this as completed in 697fae1 Oct 25, 2022
wey-gu added a commit that referenced this issue Oct 25, 2022
fix #65 [selectByIds] use id values embedding insteads of cypher param
@wey-gu
Copy link
Member

wey-gu commented Oct 25, 2022

是索引少了,加了索引就好了,谢谢

如果索引不是必须的,可以删掉索引更新包到最新 @CorvusYe 暂时绕过(#67 ) 了这个内核 bug 的触发,同时这种查询不通过索引的效率也更高一些。

@CorvusYe
Copy link
Collaborator

@wey-gu

@wey-gu
Copy link
Member

wey-gu commented Nov 16, 2022

嗯嗯,内核合并了修复,我测试了已经可以了哈,不过还没包含在 release 里,咱们要不先保持不用参数一阵子?

@CorvusYe
Copy link
Collaborator

嗯嗯,内核合并了修复,我测试了已经可以了哈,不过还没包含在 release 里,咱们要不先保持不用参数一阵子?

行,期待下个release

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants