Laravel Update break pagination #39977
Description
- Laravel Version: 8.75.0
- PHP Version: 8.0
- Database Driver & Version: Sql Server 2008
Description:
The recent Laravel upate break my entire Laravel Nova pagination.
I know SQL Server 2008 is not officially supported, we are planniing upgrade it, BUT with this release, all pagination (and my) are completely broken. It add a great breaking change!. Please, revert it.
On all pagination, I have the error:
SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Sintaxe incorreta próxima a 'offset'. (SQL:
select * from xxxxxxxxxxxxxxxxxxxx order by [xxxxxxx].[id] desc offset 30 rows fetch next 31 rows only)
Related PR
Steps To Reproduce:
Use Laravel Nova, SqlServer 2008 and install the last Laravel Version. All pagination will be broken.