PARSER_JS_PRECISION_RANGE_EXCEEDED 错误

{ [Error: parseLengthCodedNumber: JS precision range exceeded, number is >= 53 bit: "30376208567171257"] offset: 3, code: 'PARSER_JS_PRECISION_RANGE_EXCEEDED' }

nodejs mysql query 报错

看起来是 js 解析精度有问题。。这个 number 的位数大于 53，js 解析不了

查了一下这个 30376208567171257，是 mysql 生成的一个 id

mysql 上这个 id 的类型是 BIGINT(20)，怎么会这么大。。

INT is a four-byte signed integer. BIGINT is an eight-byte signed integer.

The 20 in INT(20) and BIGINT(20) means almost nothing. It's a hint for display width, it has nothing to do with storage. Practically, it affects only the ZEROFILL option

http://stackoverflow.com/questions/3135804/types-in-mysql-bigint20-vs-int20

http://dev.mysql.com/doc/refman/5.1/en/integer-types.html

 

最后查出，策划有一次把 id 改成了一个很大的数。。

 

http://www.cnblogs.com/ddeef/p/4296577.html

http://www.linuxidc.com/Linux/2012-07/65987.htm

 

转载于:https://www.cnblogs.com/hangj/p/5019682.html