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

case expression bug #2818

Closed
czpmango opened this issue Sep 8, 2021 · 0 comments · Fixed by #2819
Closed

case expression bug #2818

czpmango opened this issue Sep 8, 2021 · 0 comments · Fixed by #2819
Assignees
Labels
priority/hi-pri Priority: high type/bug Type: something is unexpected
Milestone

Comments

@czpmango
Copy link
Contributor

czpmango commented Sep 8, 2021

nebula test:

(czp@nebula) [nba]> RETURN case when null then true else false end
+-----------------------------------------+
| CASE WHEN NULL THEN true ELSE false END |
+-----------------------------------------+
| BAD_TYPE                                |
+-----------------------------------------+

neo4j test:

neo4j@neo4j> RETURN case when null then true else false end;
+-----------------------------------------+
| case when null then true else false end |
+-----------------------------------------+
| FALSE                                   |
+-----------------------------------------+

The result of yield count(BAD_TYPE) is BAD_DATA in version v2.0.1 but 0 in version v2.5.0.
IMO, aggregate function behavior in version v2.0.1 is correct, bcz you can't just treat BadNull as Null.

Related questions in the Forum: https://discuss.nebula-graph.com.cn/t/topic/5658/31

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
priority/hi-pri Priority: high type/bug Type: something is unexpected
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants