SQL Server LIMIT / OFFSET SQL Injection in laravel/framework and illuminate/database
Description
Reviewed
Apr 28, 2021
Published to the GitHub Advisory Database
Apr 29, 2021
Last updated
Jan 9, 2023
Impact
Those using SQL Server with Laravel and allowing user input to be passed directly to the
limit
andoffset
functions are vulnerable to SQL injection. Other database drivers such as MySQL and Postgres are not affected by this vulnerability.Patches
This problem has been patched on Laravel versions 6.20.26, 7.30.5, and 8.40.0.
Workarounds
You may workaround this vulnerability by ensuring that only integers are passed to the
limit
andoffset
functions, as well as theskip
andtake
functions.References