throw TypeError('value is out of bounds'); about node-mssql HOT 2 CLOSED

Using SQL Server 2014 Express:

CREATE TABLE t11s_db.t11s.Test
(
[id] INT NOT NULL,
latitude NUMERIC(8,5),
longitude NUMERIC(8,5),
PRIMARY KEY NONCLUSTERED ([id] ASC)
);

Using node.js 10.23, mssql 0.5.3, default driver (tedious):
INSERT INTO t11s.Test VALUES (@p0,@p1,@p2);
where parameters are:
INTNOTNULL: @p0 = 118583
NUMERIC(8,5): @p1 = 36.13636
NUMERIC(8,5): @p2 = -115.16225

buffer.js:784
throw TypeError('value is out of bounds');
^
TypeError: value is out of bounds
at TypeError ()
at checkInt (buffer.js:784:11)
at Buffer.writeUInt32LE (buffer.js:841:5)
at WritableTrackingBuffer.writeUInt32LE (D:\Trippo\etl\node_modules\mssql\node_modules\tedious\lib\tracking-buffer\writable-tracking-buffer.js:92:17)
at Object.TYPE.writeParameterData (D:\Trippo\etl\node_modules\mssql\node_modules\tedious\lib\data-type.js:332:25)
at new RpcRequestPayload (D:\Trippo\etl\node_modules\mssql\node_modules\tedious\lib\rpcrequest-payload.js:66:22)
at Connection.execSql (D:\Trippo\etl\node_modules\mssql\node_modules\tedious\lib\connection.js:712:56)
at D:\Trippo\etl\node_modules\mssql\lib\tedious.js:563:33
at dispense (D:\Trippo\etl\node_modules\mssql\node_modules\generic-pool\lib\generic-pool.js:247:16)
at Object.me.acquire (D:\Trippo\etl\node_modules\mssql\node_modules\generic-pool\lib\generic-pool.js:316:5)

I suspect the issue may be related to the NUMERIC data type.

from node-mssql.

Fixed in Tedious 0.2.3 - tediousjs/tedious#147

from node-mssql.