framework: Eloquent on MSSQL return error SQLSTATE[IMSSP]: Field 2 returned no data.

Laravel Version

10.23.1

PHP Version

8.1.23

Database Driver & Version

php-sqlsrv-5.11.0-1.el9

Description

OS: Alma 9

After minor update to PHP php-8.1.23-1.el9.remi.x86_64 and SQL_SRV php-sqlsrv-5.11.1-1.el9.remi.8.1.x86_64, my app broke, throw error for simple Eloquent call:

   $client= BusinessPartner::first();

Model

namespace App;

use Illuminate\Database\Eloquent\Model;

class BusinessPartner extends Model {
    protected $connection = 'sqlsrv';
    protected $table = 'dbo.OCRD';
    protected $primaryKey = 'DocEntry';
    public $timestamps = false;
}

Error:

SQLSTATE[IMSSP]: Field 2 returned no data.

select top 1 * from [dbo].[OCRD]

The above raw query (generated by Laravel) works perfectly if I run in a native SQL client.

Before upgrading, my app works perfectly fine.

Steps To Reproduce

Model

namespace App;

use Illuminate\Database\Eloquent\Model;

class BusinessPartner extends Model {
    protected $connection = 'sqlsrv';
    protected $table = 'dbo.OCRD';
    protected $primaryKey = 'DocEntry';
    public $timestamps = false;
}

(or whatever model, it will break anyway)

Tinker (or controller)

$client = BusinessPartner::first();

This line will throw error.