Argument return error

[yixinglu]

Please check the FAQ documentation before raising an issue

Describe the bug (required)

dataset is sf10 of LDBC:

(root@nebula) [sf10]> """
                   -> MATCH (person:Person)-[:KNOWS]-(friend)
                   -> WHERE id(person) == "p-24189255811776"
                   -> WITH person, collect(id(friend)) AS friends
                   -> MATCH (person:Person)-[:KNOWS*2]-(friend)-[:IS_LOCATED_IN]->(city:Place)
                   -> WHERE id(friend) != "p-24189255811776" AND id(friend) NOT IN friends
                   -> WITH person, city, friend, datetime(friend.Person.birthday) as birthday
                   -> WHERE (birthday.month==3 AND birthday.day>=21) OR
                   ->         (birthday.month==(3%12)+1 AND birthday.day<22)
                   -> WITH DISTINCT friend AS f, city AS c, person AS p
                   -> OPTIONAL MATCH (f)<-[:POST_HAS_CREATOR]-(post:Post)
                   -> OPTIONAL MATCH (post)-[e:HAS_TAG]->()<-[:HAS_INTEREST]-(p)
                   -> with f AS friend, c AS city, post, case when count(e) > 0 then 1 else 0 END as cnt
                   -> with friend, city, sum(cnt) AS commonPostCount, count(post) AS postCount
                   -> RETURN toInteger(substr(id(friend), 2)) AS personId,
                   ->        friend.Person.firstName AS personFirstName,
                   ->        friend.Person.lastName AS personLastName,
                   ->        commonPostCount - (postCount - commonPostCount) AS commonInterestScore,
                   ->        friend.Person.gender AS personGender,
                   ->        city.Place.name AS personCityName
                   -> ORDER BY commonInterestScore DESC, personId ASC
                   -> LIMIT 10
                   -> """
[ERROR (-1005)]: Argument only support vertex, but got NULL, which is type __NULL__,

Sat, 03 Dec 2022 19:52:46 CST

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