When we select a number which is of length 7 digits, couchbase converts it to a Float. In the below case, we get the result as 1000000.0 instead of 1000000. Code Sample using (var bucket = _cluster.OpenBucket()) { const string query = “SELECT 1000000 FROM DEFAULT”; var result = bucket.Query(qu…

N1Q1 Query adds .0 for numbers with length >=7

jmorris August 24, 2016, 7:52pm 10

Can you use Fiddler or Charles or some other HTTP debugger and get the response from the server and post it?

Topic		Replies	Views
Number (ulong64, cas value) conversion issue SQL++	10	1143	December 12, 2021
Some properties in my document was read like float instead of integer Sync Gateway query , dot-net	5	1195	October 3, 2022
Problem handling large numbers (BigDecimal) Java SDK	2	1618	June 25, 2018
2 cents to improve Nickel SQL++	3	1897	January 24, 2014
Couchbase .Net client returning decimal instead of int .NET SDK n1ql , dot-net	1	1856	January 15, 2016