elasticsql icon indicating copy to clipboard operation
elasticsql copied to clipboard

不支持bigint 值比较

Open tx991020 opened this issue 5 years ago • 1 comments

bigint 自动转成字符串了, 拿进去查询,查出来的结果是错的

tx991020 avatar Aug 04 '20 07:08 tx991020

@tx991020 ,这个应该本质是因为 json 的原因吧,下面这段是从 json 的 RFC 里摘出来的

This specification allows implementations to set limits on the range and precision of numbers accepted. Since software that implements IEEE 754-2008 binary64 (double precision) numbers [IEEE754] is generally available and widely used, good interoperability can be achieved by implementations that expect no more precision or range than these provide, in the sense that implementations will approximate JSON numbers within the expected precision. A JSON number such as 1E400 or 3.141592653589793238462643383279 may indicate potential interoperability problems, since it suggests that the software that created it expects receiving software to have greater capabilities for numeric magnitude and precision than is widely available.

cch123 avatar Aug 21 '20 09:08 cch123