Skip to content
This repository has been archived by the owner on Dec 1, 2022. It is now read-only.

union all bug #1208

Closed
czpmango opened this issue Jul 6, 2021 · 0 comments
Closed

union all bug #1208

czpmango opened this issue Jul 6, 2021 · 0 comments
Labels
bug Type: something is unexpected

Comments

@czpmango
Copy link
Contributor

czpmango commented Jul 6, 2021

The result of a UNION ALL cannot be passed by a pipe.

reproduce:

(czp@nebula) [nba]> lookup on player where player.name=="Tim Duncan" | yield $-.VertexID
+--------------+
| $-.VertexID  |
+--------------+
| "Tim Duncan" |
+--------------+
Got 1 rows (time spent 1823/2028 us)

(czp@nebula) [nba]> lookup on player where player.name=="Tim Duncan" union all lookup on player where player.age==42
+----------------+
| VertexID       |
+----------------+
| "Tim Duncan"   |
+----------------+
| "Tim Duncan"   |
+----------------+
| "Vince Carter" |
+----------------+
Got 3 rows (time spent 2350/2581 us)

(czp@nebula) [nba]> lookup on player where player.name=="Tim Duncan" | go from $-.VertexID over like
+-----------------+
| like._dst       |
+-----------------+
| "Manu Ginobili" |
+-----------------+
| "Tony Parker"   |
+-----------------+

(czp@nebula) [nba]> lookup on player where player.name=="Tim Duncan"  | get subgraph 0 steps from $-.VertexID
+----------------------------------------+
| _vertices                              |
+----------------------------------------+
| [("Tim Duncan" :bachelor{} :player{})] |
+----------------------------------------+
Got 1 rows (time spent 2379/2632 us)

(czp@nebula) [nba]> lookup on player where player.name=="Tim Duncan" union all lookup on player where player.age==42 | get subgraph 0 steps from $-.VertexID
[ERROR (-1009)]: SemanticError: different column names to UNION/INTERSECT/MINUS are not supported

(czp@nebula) [nba]> lookup on player where player.name=="Tim Duncan" union all lookup on player where player.age==42  | go from $-.VertexID over like
[ERROR (-1009)]: SemanticError: different column names to UNION/INTERSECT/MINUS are not supported

@czpmango czpmango added the bug Type: something is unexpected label Jul 6, 2021
@czpmango czpmango closed this as completed Jul 6, 2021
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Type: something is unexpected
Projects
None yet
Development

No branches or pull requests

1 participant