-
Notifications
You must be signed in to change notification settings - Fork 474
Open
@jhunexjun
Description
Can this package supports user-defined data types?
Expected behaviour:
just normal as built-in types like NVARCHAR, VARCHAR, etc.
Actual behaviour:
TypeError: Cannot read properties of undefined (reading 'type')
Configuration:
return await msSqlConnect.getInstance().then(pool => {
return pool.request()
.input('userId', msSql.T_USR_ID, req.query.userId)
.query('select * from SY_USR where USR_ID = @userId')
}).then(result => {
console.log('result: ', result);
return result.recordset;
}).catch(err => {
console.log(err);
});
The T_USR_ID
is a user-defined data type.
Software versions
- NodeJS: v16.13.0
- node-mssql: "mssql": "^9.1.1",
- SQL Server: Microsoft SQL Server 2019 (RTM-GDR) (KB5029377) - 15.0.2104.1 (X64)
Aug 16 2023 00:09:21
Copyright (C) 2019 Microsoft Corporation
Developer Edition (64-bit) on Windows 10 Pro 10.0 (Build 22621: ) (Hypervisor)
Metadata
Metadata
Assignees
Labels
No labels