Laravel 5.7 integration with MS SQL Server returns only(sometimes) when has LIMIT on query

I'm setting up an Application with Laravel 5.7 and I have to connect with SQL Server to make searches on this DB.

The problem is: When I run a query like SELECT [NAME] FROM [vw_view] WHERE NAME = 'NAME OF USER' on Laravel DB Facades to a SQL View

DB::connection('sqlsrv')->table('vw_view')->select(['NAME'])>where('NAME', 'NAME OF USER')->get();

The response is always an empty Collection, but if the query inputs a limit

DB::connection('sqlsrv')->table('vw_view')->select('NAME')>where('NAME', 'NAME OF USER')->limit(1)->get();

The response sometimes come, but if i increase the limit, the response start to come empty again.

When i execute this query on softwares like DBeaver, it returns the data i want. So it occurs only on Laravel execution.

from Newest questions tagged laravel-5 - Stack Overflow http://bit.ly/2SyVADu
via IFTTT