631131 - Python server serves odd floating point values for WBO modified field

Status: RESOLVED DUPLICATE of bug 631137

(Cloud Services Graveyard :: Server: Sync, defect)

Description

[Stefan Arentz | :st3fan | ⏰ EST | he/him]

I'm receiving a WBO from the server that looks like this:

{
  u'sortindex': 100,
  u'payload': ...,
  u'modified': 1296704831.3499999,
  u'id': u'kONHOobXLXdx'
}

When I look in the test.db sqlite file on the server I see that modified is set to 129670483135. It looks like a floating point issue when the modified is divided by 100.

>>> 129670483135 / 100.
1296704831.3499999

I confirmed that the above is not a JSON parse issue. The raw response from the server has the same 1296704831.3499999 value.

Comment 1

[Tarek Ziadé (:tarek)]

(I wished we would use ETags instead of timestamps in Sync)

Several things here:

- The timestamps are stored as big ints in the database - 129670483135
- We should use decimals when we return the value / 100

I'll take care of this in 631137