Dreamfactory 6.2.0 not respecting the MAX_Results setting

[domagaj]

OS: ubuntu Release: 5.15.0-56-generic
DreamFactory Version: 6.2.0
I am using sqlsrv type service.
Although I did set the API results limit to 100 000, I still get only 10 000 records when I execute the get table records, for a table that has over 13000 rows.

I have another DreamFactory Version: 2.12.0 server running on debian 4.9.0-6-amd64, connected to the same database service(same exact database server/DB/tables in use), with same max_results setting (100 000). There I get correct amount of records (13000) when I execute the API call to the same service.

I also have 6.2.0 test environment on same Ubuntu server and with same exact packages/versions and similar service to test version of the database. There is no issue with limitation on that one too.

I have cleared cache on Dreamfactory 6.2.0 server, for the specific service and the whole Dreamfactory. I performed server reboot. Nothing worked.