Updating from 4.3.1 to 4.3.2 of the sqlsrv module the insert statement is no longer returning the id of the row but just the number 1.
So in version 4.3.2 (Drupal 9.5.10) when I run this statement
$id = $connection->insert('history')
->fields([
'status' => 'testing',
'change' => 'test1',
])
->execute();
The value of $id is 1.
But in the version before 4.3.1 (Drupal 9.5.10)
The value returned is the id of the row that was inserted which is 9160
Closed: cannot reproduce
4.3
Code
I tested the update again today and it seems to be working. Not sure what happened on the Server / Local but was only getting the value 1 returned from an insert. Perhaps some sort of caching issue on my end.