full indexscan without columnHints for where v.player.name in ["Tim Duncan"]

[wey-gu]

Please check the FAQ documentation before raising an issue

Describe the bug (required)

The indexscan is without any column-hint info, thus will lead full data scan.

In large clusters, the result is exhausting memories of all storage nodes.

See details in the slack discussion attached at the bottom.

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:

(root@nebula) [basketballplayer]> explain match (v:player) where v.player.name in ["Tim Duncan"] return v limit 1
Execution succeeded (time spent 940/6819 us)

Execution Plan (optimize time 328 us)
...
-----+----------------+--------------+----------------+-----------------------------------------------
|  1 | IndexScan      | 2            |                | outputVar: {                                 |
|    |                |              |                |   "colNames": [                              |
|    |                |              |                |     "_vid"                                   |
|    |                |              |                |   ],                                         |
|    |                |              |                |   "type": "DATASET",                         |
|    |                |              |                |   "name": "__IndexScan_1"                    |
|    |                |              |                | }                                            |
|    |                |              |                | inputVar:                                    |
|    |                |              |                | space: 49                                    |
|    |                |              |                | dedup: false                                 |
|    |                |              |                | limit: 9223372036854775807                   |
|    |                |              |                | filter:                                      |
|    |                |              |                | orderBy: []                                  |
|    |                |              |                | schemaId: 50                                 |
|    |                |              |                | isEdge: false                                |
|    |                |              |                | returnCols: [                                |
|    |                |              |                |   "_vid"                                     |
|    |                |              |                | ]                                            |
|    |                |              |                | indexCtx: [                                  |
|    |                |              |                |   {                                          |
|    |                |              |                |     "columnHints": [],                       |
|    |                |              |                |     "filter": "",                            |
|    |                |              |                |     "index_id": 54                           |
|    |                |              |                |   }                                          |
|    |                |              |                | ]                                            |
-----+----------------+--------------+----------------+-----------------------------------------------
...

(root@nebula) [basketballplayer]> explain match (v:player) where v.player.name == "Tim Duncan" return v limit 1
Execution succeeded (time spent 1069/6613 us)
...
|    |                |              |                | if_track_previous_path: false            |
-----+----------------+--------------+----------------+-------------------------------------------
|  8 | IndexScan      | 2            |                | outputVar: {                             |
|    |                |              |                |   "colNames": [                          |
|    |                |              |                |     "_vid"                               |
|    |                |              |                |   ],                                     |
|    |                |              |                |   "type": "DATASET",                     |
|    |                |              |                |   "name": "__IndexScan_1"                |
|    |                |              |                | }                                        |
|    |                |              |                | inputVar:                                |
|    |                |              |                | space: 49                                |
|    |                |              |                | dedup: false                             |
|    |                |              |                | limit: 9223372036854775807               |
|    |                |              |                | filter:                                  |
|    |                |              |                | orderBy: []                              |
|    |                |              |                | schemaId: 50                             |
|    |                |              |                | isEdge: false                            |
|    |                |              |                | returnCols: [                            |
|    |                |              |                |   "_vid"                                 |
|    |                |              |                | ]                                        |
|    |                |              |                | indexCtx: [                              |
|    |                |              |                |   {                                      |
|    |                |              |                |     "columnHints": [                     |
|    |                |              |                |       {                                  |
|    |                |              |                |         "includeEnd": false,             |
|    |                |              |                |         "includeBegin": true,            |
|    |                |              |                |         "endValue": "__EMPTY__",         |
|    |                |              |                |         "beginValue": "Tim Duncan",      |
|    |                |              |                |         "scanType": "PREFIX",            |
|    |                |              |                |         "column": "name"                 |
|    |                |              |                |       }                                  |
|    |                |              |                |     ],                                   |
|    |                |              |                |     "filter": "",                        |
|    |                |              |                |     "index_id": 55                       |
|    |                |              |                |   }                                      |
|    |                |              |                | ]                                        |
-----+----------------+--------------+----------------+-------------------------------------------

Expected behavior

Include column hint in indexscan, too.

Additional context

• https://nebulagraph.slack.com/archives/CJNFUM7AR/p1665293835366569
• https://nebulagraph.slack.com/archives/CJNFUM7AR/p1665408252968829