Join related plan node misses some dependencies when profiling some queries

[yixinglu]

Please check the FAQ documentation before raising an issue

Describe the bug (required)

When we profile the query whose execution plan has join related plan node, we get the wrong dependencies in join plan node description, such as following table, the third column should have two dependencies, but now there is the only one.

-----+------------------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------
| 28 | InnerJoin        | 27           | ver: 0, rows: 121229, execTime: 259us, totalTime: 9778us                                                                                                                                                                                        | outputVar: {                                              |
|    |                  |              |                                                                                                                                                                                                                                                 |   "colNames": [                                           |
|    |                  |              |                                                                                                                                                                                                                                                 |     "__COL_0",                                            |
|    |                  |              |                                                                                                                                                                                                                                                 |     "__COL_1",                                            |
|    |                  |              |                                                                                                                                                                                                                                                 |     "__COL_2",                                            |
|    |                  |              |                                                                                                                                                                                                                                                 |     "__COL_3",                                            |
|    |                  |              |                                                                                                                                                                                                                                                 |     "_vid",                                               |
|    |                  |              |                                                                                                                                                                                                                                                 |     "idCard",                                             |
|    |                  |              |                                                                                                                                                                                                                                                 |     "VertexID"                                            |
|    |                  |              |                                                                                                                                                                                                                                                 |   ],                                                      |
|    |                  |              |                                                                                                                                                                                                                                                 |   "type": "DATASET",                                      |
|    |                  |              |                                                                                                                                                                                                                                                 |   "name": "__Filter_9"                                    |
|    |                  |              |                                                                                                                                                                                                                                                 | }                                                         |
|    |                  |              |                                                                                                                                                                                                                                                 | inputVar: {                                               |
|    |                  |              |                                                                                                                                                                                                                                                 |   "rightVar": {                                           |
|    |                  |              |                                                                                                                                                                                                                                                 |     "__Limit_3": 0                                        |
|    |                  |              |                                                                                                                                                                                                                                                 |   },                                                      |
|    |                  |              |                                                                                                                                                                                                                                                 |   "leftVar": {                                            |
|    |                  |              |                                                                                                                                                                                                                                                 |     "__Filter_27": 0                                      |
|    |                  |              |                                                                                                                                                                                                                                                 |   }                                                       |
|    |                  |              |                                                                                                                                                                                                                                                 | }                                                         |
|    |                  |              |                                                                                                                                                                                                                                                 | hashKeys: [                                               |
|    |                  |              |                                                                                                                                                                                                                                                 |   "$__Filter_27._vid"                                     |
|    |                  |              |                                                                                                                                                                                                                                                 | ]                                                         |
|    |                  |              |                                                                                                                                                                                                                                                 | probeKeys: [                                              |
|    |                  |              |                                                                                                                                                                                                                                                 |   "$-.VertexID"                                           |
|    |                  |              |                                                                                                                                                                                                                                                 | ]                                                         |
|    |                  |              |                                                                                                                                                                                                                                                 | kind: InnerJoin                                           |
-----+------------------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------

The Join plan node inheriting the SingleDependencyNode result in the incorrect result.

class Join : public SingleDependencyNode {
 public:
};

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

[Shylock-Hg]

What's the query?

[Shylock-Hg]

It's by designed. Join has only one dependency, but BiJoin has two.