JSON documents numeric field values are automatically rounding

[nhealthlive]

We have the following @Document model

Here the surId is a type of Long, But when we set long-range values, It automatically rounds to x000

That is if I set surId as 8301034833169298414 it rounds to 8301034833169298000

If I set surId as 8301034833169297919 it rounds to 8301034833169297000

This can be try from the redis insight.

Is there any range limit for NumericField? Any workarounds that you can suggest @bsbodden

• Redis OM Spring Version : 0.8.7
• Module versions RediSearch v. 2.8.9 RedisJSON v. 2.6.7
• Redis Standalone Version: 7.2.3
• Spring boot version : 3.1.3

[bsbodden]

Unfortunately this is a JSON engine limitation, as the image below shows it happens on insertion. One possible workaround would be to tell Spring to serialize and store it as a string, but then you won't be able to indexed as a number, so features like range indexes would work

see related https://www.techempower.com/blog/2016/07/05/mangling-json-numbers/