OverflowError

[squirrelfish]

Bug Report

run tx.run("MERGE (a:Person {id: $id}) ", id=10000000000000) get OverflowError: Integer 10000000000000 out of range

My Environment

Python Version: 3.11.2
Driver Version: 5.6.0
Server Version and Edition: 5.6.0 community
Operating System: Windows 10

[robsdedude]

Hi and thanks for reaching out. This is a limitation of the DBMS (and is also reflected by the protocol). If you look here https://neo4j.com/docs/api/python-driver/current/api.html#core-data-types you'll see that the DBMS is using long to store integers. So this limits all integers going through neo4j to be in the range -2147483648 <= x <= 2147483647

I'll close this issue as it's not a bug. But please feel free to keep commenting if you have further questions.

EDIT:
My bad, java's long is 64 bits. So the range is actually -9223372036854775808 == -(2**63) <= x <= 2**63-1 == 9223372036854775807.
With that being said, I can't reproduce the OverflowError with the query tx.run("MERGE (a:Person {id: $id}) ", id=10000000000000) you posted.