N1QL TOSTRING returnimg number in exponential format

SQL++
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

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.