match doesn't return result

[Nicole00]

when vertex's multi tags have the same property col1， then match(v:person{col1:"12"}) return v does not return data.

[HarrisChu]

https://github.com/vesoft-inc/nebula-graph/issues/726

[Shylock-Hg]

Has index data in it?

[Nicole00]

Has index data in it?

Yes, if no index built on the property, it will print the error message.

[HarrisChu]

add profile

1. scan in index, and then find 1 row.
2. filter with condition VERTEX.col1=="12"
3. as there are two tag with some property col1, it may compare "12" with odps tag property, and dedup.

(root@nebula) [test]> profile match (v:person{col1:"12"}) return v
Empty set (time spent 16969/56738 us)

Execution Plan (optimize time 445 us)

-----+-------------+--------------+------------------------------------------------------+--------------------------------------------------
| id | name        | dependencies | profiling data                                       | operator info                                   |
-----+-------------+--------------+------------------------------------------------------+--------------------------------------------------
|  9 | Project     | 8            | ver: 0, rows: 0, execTime: 439us, totalTime: 440us   | outputVar: [                                    |
|    |             |              |                                                      |   {                                             |
|    |             |              |                                                      |     "colNames": [                               |
|    |             |              |                                                      |       "v"                                       |
|    |             |              |                                                      |     ],                                          |
|    |             |              |                                                      |     "type": "DATASET",                          |
|    |             |              |                                                      |     "name": "__Project_9"                       |
|    |             |              |                                                      |   }                                             |
|    |             |              |                                                      | ]                                               |
|    |             |              |                                                      | inputVar: __Filter_8                            |
|    |             |              |                                                      | columns: [                                      |
|    |             |              |                                                      |   "$v"                                          |
|    |             |              |                                                      | ]                                               |
-----+-------------+--------------+------------------------------------------------------+--------------------------------------------------
|  8 | Filter      | 7            | ver: 0, rows: 0, execTime: 1us, totalTime: 2us       | outputVar: [                                    |
|    |             |              |                                                      |   {                                             |
|    |             |              |                                                      |     "colNames": [                               |
|    |             |              |                                                      |       "v",                                      |
|    |             |              |                                                      |       "__COL_0"                                 |
|    |             |              |                                                      |     ],                                          |
|    |             |              |                                                      |     "type": "DATASET",                          |
|    |             |              |                                                      |     "name": "__Filter_8"                        |
|    |             |              |                                                      |   }                                             |
|    |             |              |                                                      | ]                                               |
|    |             |              |                                                      | inputVar: __Project_7                           |
|    |             |              |                                                      | condition: !(hasSameEdgeInPath($-.__COL_0))     |
-----+-------------+--------------+------------------------------------------------------+--------------------------------------------------
|  7 | Project     | 6            | ver: 0, rows: 0, execTime: 4us, totalTime: 5us       | outputVar: [                                    |
|    |             |              |                                                      |   {                                             |
|    |             |              |                                                      |     "colNames": [                               |
|    |             |              |                                                      |       "v",                                      |
|    |             |              |                                                      |       "__COL_0"                                 |
|    |             |              |                                                      |     ],                                          |
|    |             |              |                                                      |     "type": "DATASET",                          |
|    |             |              |                                                      |     "name": "__Project_7"                       |
|    |             |              |                                                      |   }                                             |
|    |             |              |                                                      | ]                                               |
|    |             |              |                                                      | inputVar: __Project_6                           |
|    |             |              |                                                      | columns: [                                      |
|    |             |              |                                                      |   "startNode($-._path) AS v",                   |
|    |             |              |                                                      |   "reversePath(PathBuild[$-._path]) AS __COL_0" |
|    |             |              |                                                      | ]                                               |
-----+-------------+--------------+------------------------------------------------------+--------------------------------------------------
|  6 | Project     | 5            | ver: 0, rows: 0, execTime: 2684us, totalTime: 2687us | outputVar: [                                    |
|    |             |              |                                                      |   {                                             |
|    |             |              |                                                      |     "colNames": [                               |
|    |             |              |                                                      |       "_path"                                   |
|    |             |              |                                                      |     ],                                          |
|    |             |              |                                                      |     "type": "DATASET",                          |
|    |             |              |                                                      |     "name": "__Project_6"                       |
|    |             |              |                                                      |   }                                             |
|    |             |              |                                                      | ]                                               |
|    |             |              |                                                      | inputVar: __Filter_5                            |
|    |             |              |                                                      | columns: [                                      |
|    |             |              |                                                      |   "PathBuild[VERTEX]"                           |
|    |             |              |                                                      | ]                                               |
-----+-------------+--------------+------------------------------------------------------+--------------------------------------------------
|  5 | Filter      | 13           | ver: 0, rows: 0, execTime: 57us, totalTime: 58us     | outputVar: [                                    |
|    |             |              |                                                      |   {                                             |
|    |             |              |                                                      |     "colNames": [],                             |
|    |             |              |                                                      |     "type": "DATASET",                          |
|    |             |              |                                                      |     "name": "__Filter_5"                        |
|    |             |              |                                                      |   }                                             |
|    |             |              |                                                      | ]                                               |
|    |             |              |                                                      | inputVar: __GetVertices_4                       |
|    |             |              |                                                      | condition: (VERTEX.col1=="12")                  |
-----+-------------+--------------+------------------------------------------------------+--------------------------------------------------
| 13 | GetVertices | 10           | {                                                    | outputVar: [                                    |
|    |             |              | ver: 0, rows: 1, execTime: 28us, totalTime: 1903us   |   {                                             |
|    |             |              | "storaged0":9779 exec/total: 328(us)/672(us)         |     "colNames": [],                             |
|    |             |              | total_rpc: 1837(us)                                  |     "type": "DATASET",                          |
|    |             |              | }                                                    |     "name": "__GetVertices_4"                   |
|    |             |              |                                                      |   }                                             |
|    |             |              |                                                      | ]                                               |
|    |             |              |                                                      | inputVar: __IndexScan_1                         |
|    |             |              |                                                      | space: 6                                        |
|    |             |              |                                                      | dedup: true                                     |
|    |             |              |                                                      | limit: 9223372036854775807                      |
|    |             |              |                                                      | filter:                                         |
|    |             |              |                                                      | orderBy: []                                     |
|    |             |              |                                                      | src: $_vid                                      |
|    |             |              |                                                      | props: [                                        |
|    |             |              |                                                      |   {                                             |
|    |             |              |                                                      |     "props": [                                  |
|    |             |              |                                                      |       "col1",                                   |
|    |             |              |                                                      |       "col2",                                   |
|    |             |              |                                                      |       "col3",                                   |
|    |             |              |                                                      |       "col4",                                   |
|    |             |              |                                                      |       "col5",                                   |
|    |             |              |                                                      |       "col6",                                   |
|    |             |              |                                                      |       "col7",                                   |
|    |             |              |                                                      |       "col8",                                   |
|    |             |              |                                                      |       "col9",                                   |
|    |             |              |                                                      |       "col10",                                  |
|    |             |              |                                                      |       "col11",                                  |
|    |             |              |                                                      |       "col12",                                  |
|    |             |              |                                                      |       "col13",                                  |
|    |             |              |                                                      |       "name",                                   |
|    |             |              |                                                      |       "age",                                    |
|    |             |              |                                                      |       "born",                                   |
|    |             |              |                                                      |       "_tag"                                    |
|    |             |              |                                                      |     ],                                          |
|    |             |              |                                                      |     "tagId": 7                                  |
|    |             |              |                                                      |   },                                            |
|    |             |              |                                                      |   {                                             |
|    |             |              |                                                      |     "props": [                                  |
|    |             |              |                                                      |       "col1",                                   |
|    |             |              |                                                      |       "col2",                                   |
|    |             |              |                                                      |       "col3",                                   |
|    |             |              |                                                      |       "col4",                                   |
|    |             |              |                                                      |       "col5",                                   |
|    |             |              |                                                      |       "col6",                                   |
|    |             |              |                                                      |       "col7",                                   |
|    |             |              |                                                      |       "_tag"                                    |
|    |             |              |                                                      |     ],                                          |
|    |             |              |                                                      |     "tagId": 24                                 |
|    |             |              |                                                      |   }                                             |
|    |             |              |                                                      | ]                                               |
|    |             |              |                                                      | exprs:                                          |
-----+-------------+--------------+------------------------------------------------------+--------------------------------------------------
| 10 | IndexScan   | 0            | ver: 0, rows: 1, execTime: 0us, totalTime: 4525us    | outputVar: [                                    |
|    |             |              |                                                      |   {                                             |
|    |             |              |                                                      |     "colNames": [                               |
|    |             |              |                                                      |       "_vid"                                    |
|    |             |              |                                                      |     ],                                          |
|    |             |              |                                                      |     "type": "DATASET",                          |
|    |             |              |                                                      |     "name": "__IndexScan_1"                     |
|    |             |              |                                                      |   }                                             |
|    |             |              |                                                      | ]                                               |
|    |             |              |                                                      | inputVar:                                       |
|    |             |              |                                                      | space: 6                                        |
|    |             |              |                                                      | dedup: false                                    |
|    |             |              |                                                      | limit: 9223372036854775807                      |
|    |             |              |                                                      | filter:                                         |
|    |             |              |                                                      | orderBy: []                                     |
|    |             |              |                                                      | schemaId: 7                                     |
|    |             |              |                                                      | isEdge: false                                   |
|    |             |              |                                                      | returnCols: [                                   |
|    |             |              |                                                      |   "_vid"                                        |
|    |             |              |                                                      | ]                                               |
|    |             |              |                                                      | indexCtx: [                                     |
|    |             |              |                                                      |   {                                             |
|    |             |              |                                                      |     "columnHints": [                            |
|    |             |              |                                                      |       {                                         |
|    |             |              |                                                      |         "endValue": "__EMPTY__",                |
|    |             |              |                                                      |         "beginValue": "\"12",                   |
|    |             |              |                                                      |         "scanType": "PREFIX",                   |
|    |             |              |                                                      |         "column": "col1"                        |
|    |             |              |                                                      |       }                                         |
|    |             |              |                                                      |     ],                                          |
|    |             |              |                                                      |     "filter": "",                               |
|    |             |              |                                                      |     "index_id": 16                              |
|    |             |              |                                                      |   }                                             |
|    |             |              |                                                      | ]                                               |
-----+-------------+--------------+------------------------------------------------------+--------------------------------------------------
|  0 | Start       |              | ver: 0, rows: 0, execTime: 0us, totalTime: 39us      | outputVar: [                                    |
|    |             |              |                                                      |   {                                             |
|    |             |              |                                                      |     "colNames": [],                             |
|    |             |              |                                                      |     "type": "DATASET",                          |
|    |             |              |                                                      |     "name": "__Start_0"                         |
|    |             |              |                                                      |   }                                             |
|    |             |              |                                                      | ]                                               |
-----+-------------+--------------+------------------------------------------------------+--------------------------------------------------

[Shylock-Hg]

Has index data in it?

Yes, if no index built on the property, it will print the error message.

There are two concepts. Has the index and has the index data. The tag has index but maybe has no index data in storage. For example, insert vertex first then create index.

[Nicole00]

Has index data in it?

Yes, if no index built on the property, it will print the error message.

There are two concepts. Has the index and has the index data. The tag has index but maybe has no index data in storage. For example, insert vertex first then create index.

The problem is : LOOKUP can return the right result, but MATCH return nothing.

[Shylock-Hg]

It's a known issue, for the same name property the behavior of match query is undefined, that we select the property value by chance.

[Shylock-Hg]

@randomJoe211 Do we notice this to user in document?

[whitewum]

@randomJoe211 Do we notice this to user in document?

Dozens of times.

[critical27]

Which one issue do we need to use? Do we need to fix? @Sophie-Xie @CPWstatic, just track them in one issue.