-
Notifications
You must be signed in to change notification settings - Fork 1.9k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Bug: [SQLSRV] Incorrect syntax near 'OFFSET' #5663
Comments
Seems we could or should use LIMIT 1 when using first() |
MS SQL Server doesn't suppor the |
@demirkaric Do you still use MSSQL Server 2008? |
|
Microsoft SQL Server 2012 also reached the end of life: Jul 12, 2022 |
@demirkaric Thank you for reporting. I sent a PR to fix the docs: #8489 |
PHP Version
7.4
CodeIgniter4 Version
4.1.8
CodeIgniter4 Installation Method
Composer (using
codeigniter4/appstarter
)Which operating systems have you tested for this bug?
Windows, Linux
Which server did you use?
apache
Database
MSSQL Server 2008
What happened?
In the documentation it's stated: MSSQL via the SQLSRV driver (version 2005 and above only)
This is wrong statement, let's check the next code sample in the Steps to Reproduce.
Steps to Reproduce
This produces next query:
Expected Output
Since we use version MSSQL 2008 and OFFSET is supported from version 2012 and above.
This should be fixed or the documentation should be corrected.
Anything else?
No response
The text was updated successfully, but these errors were encountered: