I am embarking on my first project using Neo4J as my primary data-store. We are using Snowflake.Net for our ID generation system.
This all worked well in the beginning as we were saving the ID's as strings to overcome limitations of longs in javascript. this how ever proved to be a poor design decision as it made things like paging very difficult.
We have subsequently re-factored so that we are using a long (64bit int) as an Id Which Generates an ID like this: 5836423911667012000 However now we are not able to match using ID's (Please see attached Images) http://i28.photobucket.com/albums/c222/primalfear83/c1_zpsa2893e35.png http://i28.photobucket.com/albums/c222/primalfear83/c2_zps6b335e02.png
Our Id field does work if we use a 32bit int, but not with any 64bit int values. So we can look up on an ID 57073.
Any insight as to the cause behind this, or possibly solutions to fix would be greatly appreciated.
The issue appears to be in the Neo4J Web administration UI, where on the output on the UI is not a true indication of what is happening in the database.
I have done a few more tests and all my statements are now working fine, as long as i don't try and use the values displayed in the web admin... True ID: 436565277858205696 | Web Admin: 436565277858205700 True ID: 436570021204987904 | Web Admin: 436570021204987900
