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

[incompatible OpenCypher] with size() for degrees #2625

Open
wey-gu opened this issue Jul 22, 2021 · 1 comment
Open

[incompatible OpenCypher] with size() for degrees #2625

wey-gu opened this issue Jul 22, 2021 · 1 comment
Labels
type/feature req Type: feature request

Comments

@wey-gu
Copy link
Contributor

wey-gu commented Jul 22, 2021

Describe the bug (must be provided)
Syntax parsing is not expected.

How To Reproduce(must be provided)

MATCH p=(n:player)-[]->(m:player) WITH p, size((m)-[]->()) as right_out, size((n)<-[]-()) as left_in \
WHERE right_out == 0 AND left_in == 0 RETURN p;
(root@nebula) [basketballplayer]> MATCH p=(n:player)-[]->(m:player) WITH p, size((m)-[]->()) as right_out, size((n)<-[]-()) as left_in \
                               -> WHERE right_out == 0 AND left_in == 0 RETURN p;
[ERROR (-7)]: SyntaxError: syntax error near `]->()) a'

Thu, 22 Jul 2021 12:16:33 CST

Expected behavior

MATCH p=(n:Person)-[]->(m:Movie) WITH p, size((m)-[]->()) as left_out, size((n)<-[]-()) as left_in
WHERE right_out = 0 AND right_in = 0 RETURN p;

╒══════════════════════════════════════════════════════════════════════╕
│"p"                                                                   │
╞══════════════════════════════════════════════════════════════════════╡
│[{"louvain":5,"degree":0.0,"name":"Emil Eifrem","born":1978},{"roles":│
│["Emil"]},{"louvain":5,"degree":8.0,"tagline":"Welcome to the Real Wor│
│ld","votes":372,"title":"The Matrix","released":1999}]                │
├──────────────────────────────────────────────────────────────────────┤
│[{"louvain":5,"degree":0.0,"name":"Joel Silver","born":1952},{},{"louv│
│ain":5,"degree":8.0,"tagline":"Welcome to the Real World","votes":372,│
│"title":"The Matrix","released":1999}]                                │
├──────────────────────────────────────────────────────────────────────┤

...

Additional context

related topic in forum: https://discuss.nebula-graph.com.cn/t/topic/4947

@jievince
Copy link
Contributor

We have not support use pattern in WITH yet

@CPWstatic CPWstatic transferred this issue from vesoft-inc/nebula-graph Aug 27, 2021
@CPWstatic CPWstatic added the type/feature req Type: feature request label Aug 28, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/feature req Type: feature request
Projects
None yet
Development

No branches or pull requests

3 participants