Bug: IN clause does not find a node

[Claus1]

Kùzu version

0.4.2, 0.5.0

What operating system are you using?

Ubuntu 22

What happened?

I modified a Your First Graph example by adding ID property and making it as primary key.
in a query

   MATCH (a:User)-[r:LivesIn]->(b:City)
    WHERE b.ID in [1]
    RETURN a.*;

kuzu returns empty result, but

    MATCH (a:User)-[r:LivesIn]->(b:City)
    WHERE b.ID = 1
    RETURN a.*;

return the correct node.

Are there known steps to reproduce?

Code for reproducing:

import kuzu

# Initialize database
db = kuzu.Database("db")
conn = kuzu.Connection(db)

# Create schema
conn.execute("CREATE NODE TABLE User(name STRING, age INT64, ID SERIAL, PRIMARY KEY (ID))")
conn.execute("CREATE NODE TABLE City(name STRING, population INT64, ID SERIAL, PRIMARY KEY (ID))")    
conn.execute("CREATE REL TABLE LivesIn(FROM User TO City)")

# Insert data
conn.execute('COPY User FROM "./user.csv"')
conn.execute('COPY City FROM "./city.csv"')    

conn.execute(f"""
        MATCH (a:User), (b:City)
        WHERE a.ID = 1 AND b.ID = 1
        CREATE (a)-[r:LivesIn]->(b)            
        RETURN r.*
        """)

# Execute Cypher query
response = conn.execute(
    """
    MATCH (a:User)-[r:LivesIn]->(b:City)
    WHERE b.ID = 1
    RETURN a.*;
    """
)
while response.has_next():
    print(response.get_next())

response = conn.execute(
    """
    MATCH (a:User)-[r:LivesIn]->(b:City)
    WHERE b.ID in [1]
    RETURN a.*;
    """
)
while response.has_next():
    print(response.get_next())

[andyfengHKU]

Hi @Claus1,

thanks for the report. This should be fixed in #4044. It will be available in our nightly build tmr.