Browser show db content have a bug 。 A long content

objectbox / objectbox-java

Android Database - first and fast, lightweight on-device vector database

https://objectbox.io

Apache License 2.0

4.4k stars 302 forks source link

Browser show db content have a bug 。 A long content #500

Closed Lxingzhi closed 6 years ago

Lxingzhi commented 6 years ago

Issue Basics

version 1.5.0 2.0.0-beta
Reproducibility : always

Description

Browser show db content have a bug 。 A long content

eg： objectboxbug

greenrobot-team commented 6 years ago

Thanks for reporting.

Can reproduce using our note example. -ut

greenrobot-team commented 6 years ago

Also, when trying to filter for a large value the API returns {error: {code: 500, message: "stol: out of range"}}.

edit: OK, the error occurs if the value exceeds 2^31-1 (Java Integer.MAX_VALUE, 2147483647). -ut

greenrobot-team commented 6 years ago

Just to give an update on this (working on this internally):

the filter (see above comment) issue will be fixed with the next update,
the display issue is due to JavaScript not supporting 64bit signed integers, instead it uses floating point. This results in a rounding error when converting from JSON (what the API returns) to JavaScript objects (what data browser uses). You can get the correct numers by looking at the JSON download (JSON has no range limit on numbers). Still looking for a solution.

-ut

greenrobot-team commented 6 years ago

The display bug was fixed internally (by sending non-floating point 64-bit numbers as JSON String). This should be available with the next update. -ut

Lxingzhi commented 6 years ago

@greenrobot-team Thank you for your answer