N1QL TOSTRING returnimg number in exponential format

#1

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?

Best,
Peter

How to join key/value documents with JSON documents
#2

Hi, this has been fixed in 4.1.

#3

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

#4

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