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

when INSERT data, using FETCH can find new data but MATCH can't #4074

Closed
QingZ11 opened this issue Mar 24, 2022 · 1 comment
Closed

when INSERT data, using FETCH can find new data but MATCH can't #4074

QingZ11 opened this issue Mar 24, 2022 · 1 comment
Assignees
Labels
community Source: who proposed the issue need info Solution: need more information (ex. can't reproduce) type/bug Type: something is unexpected
Milestone

Comments

@QingZ11
Copy link
Contributor

QingZ11 commented Mar 24, 2022

  • version: 2.5.1

  • description

run INSERT query:

insert vertex catalog (aaa,bbb,ccc,ddd,eee,fff,ggg) values "tttt":("111","222","333","444","555",now(),now());

use FETCH statement:

fetch prop on catalog 'tttt'

result:
image
but, use MATCH statement:

match (v:catalog) where id(v) == 'tttt' return v

result:
image

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

@QingZ11 QingZ11 added the type/bug Type: something is unexpected label Mar 24, 2022
@Sophie-Xie Sophie-Xie added this to the v3.1.0 milestone Mar 24, 2022
@Sophie-Xie Sophie-Xie added need info Solution: need more information (ex. can't reproduce) community Source: who proposed the issue labels Apr 13, 2022
@Sophie-Xie Sophie-Xie modified the milestones: v3.1.0, v3.2.0 Apr 24, 2022
@CPWstatic
Copy link
Contributor

(root@nebula) [nba]> insert vertex catalog (aaa,bbb,ccc,ddd,eee,fff,ggg) values "tttt":("111","222","333","444","555",now(),now());
Execution succeeded (time spent 2300/2524 us)

Thu, 26 May 2022 20:00:06 CST

(root@nebula) [nba]> fetch prop on catalog 'tttt'
[ERROR (-1009)]: SemanticError: Missing yield clause.

Thu, 26 May 2022 20:00:12 CST

(root@nebula) [nba]> fetch prop on catalog 'tttt' yield vertex
[ERROR (-1004)]: SyntaxError: please add alias when using `vertex'. near `vertex'

Thu, 26 May 2022 20:00:18 CST

(root@nebula) [nba]> fetch prop on catalog 'tttt' yield vertex as v
+-----------------------------------------------------------------------------------------------------------------+
| v                                                                                                               |
+-----------------------------------------------------------------------------------------------------------------+
| ("tttt" :catalog{aaa: "111", bbb: "222", ccc: "333", ddd: "444", eee: "555", fff: 1653566406, ggg: 1653566406}) |
+-----------------------------------------------------------------------------------------------------------------+
Got 1 rows (time spent 2707/3074 us)

Thu, 26 May 2022 20:00:23 CST

(root@nebula) [nba]> match (v:catalog) where id(v) == 'tttt' return v
+-----------------------------------------------------------------------------------------------------------------+
| v                                                                                                               |
+-----------------------------------------------------------------------------------------------------------------+
| ("tttt" :catalog{aaa: "111", bbb: "222", ccc: "333", ddd: "444", eee: "555", fff: 1653566406, ggg: 1653566406}) |
+-----------------------------------------------------------------------------------------------------------------+
Got 1 rows (time spent 3553/3867 us)

Thu, 26 May 2022 20:00:28 CST

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
community Source: who proposed the issue need info Solution: need more information (ex. can't reproduce) type/bug Type: something is unexpected
Projects
None yet
Development

No branches or pull requests

4 participants