N1QL TOSTRING returnimg number in exponential format

Hi Team,

select ‘s_’ || TOSTRING(p.issueId)
from NAPS_DATA p
WHERE p.entityType == 'p’
AND p.id = ‘p_275965_100514614’

Is returning issueId as “s_1.00514614e+08” . Is there a way to not have it converted to string in exponential format?


Hi, this has been fixed in 4.1.

Gerald - that’s great news; having same issue. Is there any workaround if we have 4.0?

Unfortunately, it requires 4.1 or later. There is patch or workaround to 4.0 for this.