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 when return error #4710

Closed
nevermore3 opened this issue Oct 11, 2022 · 1 comment
Closed

case when return error #4710

nevermore3 opened this issue Oct 11, 2022 · 1 comment
Assignees
Labels
severity/major Severity of bug type/bug Type: something is unexpected
Milestone

Comments

@nevermore3
Copy link
Contributor

Please check the FAQ documentation before raising an issue

Describe the bug (required)

(root@nebula) [nba]>  match (a:player)-[e:like]->(b) with case when e.likeness > 90 then e else {likeness:13} end as n return  n.likeness
+------------+
| n.likeness |
+------------+
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
| 13         |
+------------+
Got 81 rows (time spent 36266/38220 us)

Tue, 11 Oct 2022 10:40:41 CST

(root@nebula) [nba]>  match (a:player)-[e:like]->(b) with case when e.likeness > 90 then e else {likeness:13} end as n return n, n.likeness
+------------------------------------------------------------------+------------+
| n                                                                | n.likeness |
+------------------------------------------------------------------+------------+
| [:like "Shaquille O'Neal"->"JaVale McGee" @0 {likeness: 100}]    | 100        |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| [:like "Dejounte Murray"->"LeBron James" @0 {likeness: 99}]      | 99         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| [:like "Dejounte Murray"->"Danny Green" @0 {likeness: 99}]       | 99         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| [:like "Dejounte Murray"->"James Harden" @0 {likeness: 99}]      | 99         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| [:like "Paul George"->"Russell Westbrook" @0 {likeness: 95}]     | 95         |
| [:like "Dejounte Murray"->"Russell Westbrook" @0 {likeness: 99}] | 99         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| [:like "Dejounte Murray"->"Marco Belinelli" @0 {likeness: 99}]   | 99         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| [:like "Tony Parker"->"Tim Duncan" @0 {likeness: 95}]            | 95         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| [:like "Dejounte Murray"->"Tim Duncan" @0 {likeness: 99}]        | 99         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| [:like "Dejounte Murray"->"Chris Paul" @0 {likeness: 99}]        | 99         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| [:like "Marc Gasol"->"Paul Gasol" @0 {likeness: 99}]             | 99         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| [:like "Dejounte Murray"->"Kyle Anderson" @0 {likeness: 99}]     | 99         |
| [:like "Paul Gasol"->"Marc Gasol" @0 {likeness: 99}]             | 99         |
| [:like "Dejounte Murray"->"Kevin Durant" @0 {likeness: 99}]      | 99         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| [:like "LeBron James"->"Ray Allen" @0 {likeness: 100}]           | 100        |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| [:like "Tim Duncan"->"Tony Parker" @0 {likeness: 95}]            | 95         |
| [:like "Dejounte Murray"->"Tony Parker" @0 {likeness: 99}]       | 99         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| [:like "Tony Parker"->"Manu Ginobili" @0 {likeness: 95}]         | 95         |
| {likeness: 13}                                                   | 13         |
| [:like "Tim Duncan"->"Manu Ginobili" @0 {likeness: 95}]          | 95         |
| [:like "Dejounte Murray"->"Manu Ginobili" @0 {likeness: 99}]     | 99         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
| {likeness: 13}                                                   | 13         |
+------------------------------------------------------------------+------------+

Your Environments (required)

  • OS: uname -a
  • Compiler: g++ --version or clang++ --version
  • CPU: lscpu
  • Commit id (e.g. a3ffc7d8)

How To Reproduce(required)

Steps to reproduce the behavior:

  1. Step 1
  2. Step 2
  3. Step 3

Expected behavior

Additional context

@jinyingsunny
Copy link

checked on 3.3-rc

@jinyingsunny jinyingsunny added the severity/major Severity of bug label Nov 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/major Severity of bug type/bug Type: something is unexpected
Projects
None yet
Development

No branches or pull requests

4 participants