long values greater than 2^53 need to be stored as string

Farshid Ghods added a comment - 08/Oct/12 3:42 PM - edited erver: Windows 2008 R2 64 bit Client: C# Confirmed Json string being written with .Save and the long value is correct during the save function. In read function and also the Admin UI the value of the long field is incorrect. Here is an example: Document: fbUser_634851623223408516 { "CreatedTime": "/Date(1349565522340-0700)/", "TableExpires": "/Date(-62135568000000-0800)/", "UserId": 634851623223408500, "UserName": "634851623223408516", "UserPin": "888", "recType": "fbUser" } UserId should be same as UserName as was confirmed during the .Save function. Any ideas why the long [DataMember] [JsonProperty(PropertyName = "UserId")] public long UserId { get; set; }

Nader Rahimizad added a comment - 08/Oct/12 3:55 PM You can simply see this bug by entering 634851623223408516 into the UserId field on the AdminUI and you will see it round up when you click save!

Farshid Ghods added a comment - 08/Oct/12 5:35 PM Filipe, should QE reproduce this and append diags or you are already aware of this limitation for a value great than pow(2,59) which is the value posted by the user. not sure whethere we store this as long or integer ?

Filipe Manana added a comment - 08/Oct/12 5:45 PM You're hitting a limit of most (if not all) JavaScript engines. They can't represent number larger than 2 ** 53. See the following in node (V8) and Spidermonkey: fdmanana 23:43:24 ~ > node > 634851623223408516 634851623223408500 > fdmanana 23:43:36 ~ > fdmanana 23:43:37 ~ > js > 634851623223408516 634851623223408500 > fdmanana 23:43:41 ~ > fdmanana 23:43:42 ~ > Anyone who wants to store such large numbers, will have to store them as strings.

Filipe Manana added a comment - 08/Oct/12 5:46 PM Nothing we can do about this.

Farshid Ghods added a comment - 08/Oct/12 5:49 PM reopening the ticket and assigning this to MC for documentation

Filipe Manana added a comment - 08/Oct/12 5:53 PM Actually, even ECMA spec mentions it: http://ecma262-5.com/ELS5_HTML.htm#Section_8.5

Nader Rahimizad added a comment - 08/Oct/12 8:48 PM You will also need to document this in your .Net sdk as this is a C# long... I converted my app to strings instead of longs to overcome this shortcoming. Thanks

MC Brown added a comment - 16/Oct/12 9:36 AM Documentation has been updated in the .NET and Couchbase Server manuals. I'll replicate to the other SDKs later today.