request.output + OUTPUT clause returns value in recordset field instead of output field

[RicardoAALL]

Perhaps, I'm misunderstanding how the output method works but here is the code I am using:

Executing the following code

const fullName = "bob smith"
let inserted = await sql.connect(sqlConfig).request()
  .input('FullName', sql.NVarChar(255), fullName)
  .output('ID', sql.Int)
  .query(`
    INSERT INTO test.dbo.test_table(FullName) 
    OUTPUT INSERTED.ID 
    VALUES(@FullName)
  `)
console.log(inserted)

Expected behaviour:

I expected the value returned to be accessed using:

inserted.output

Actual behaviour:

In order to actually access the output value I have to use the recordset field:

inserted.recordset[0].ID

The output field does show the ID property but the value is set to null.

Configuration:

// basic config from example

Software versions

• NodeJS: 18+
• node-mssql: 10.0.1
• SQL Server: 2019

[dhensby]

Sorry for the delay in looking into this.

I also see that behaviour and it is indeed a bit confusing. I think the recordset(s) is the right place for this data to be populated and the presence of the output property is confusing. If you insert many rows, this should be an array of data, not a fixed object, so the implied access of inserted.output.ID would be incorrect.

I'll do some digging into the output property and what we can / should do with it.