Querying on index with very long number about dynamodb.sql HOT 6 CLOSED

I suspect in this case it might be that you're running into a case where you start to lose precisions with floating point. e.g.

I get these in LinqPad:

    double a = 10205471065416239;
    double b = 10205471065416240;
    double c = 10205471065416241;
    double d = 10205471065416242;

    double e = 10205471065416056;
    double f  = 10205471065416057;

    a.ToString("r").Dump(); // 10205471065416240
    b.ToString("r").Dump(); // 10205471065416240
    c.ToString("r").Dump(); // 10205471065416240
    d.ToString("r").Dump(); // 10205471065416242
    e.ToString("r").Dump(); // 10205471065416056
    f.ToString("r").Dump();  // 10205471065416056

So looks like we may not have solved the problem the last time around.

In .Net we're somewhat limited with what we can do with a 64-bit double, but in cases where there is no decimals we can get away with using a BigInteger.

How is the key represented in your code? Are they stored as a int64?

from dynamodb.sql.

Yeah, they are "long". I've discovered that precesion go out when the long is even.

from dynamodb.sql.

ok, thanks, I think I know what to do here - use BigInteger when there's no decimal - to solve this

from dynamodb.sql.

Sounds good.

from dynamodb.sql.

@zairnamlas - did the fix work for you guys? If so, I'll close the issue

from dynamodb.sql.

Yeah, it looks like ok. It is fetching results now. Thanks Yan.

from dynamodb.sql.