Skip to content
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

Update LimitClause doesn't use proper Postgres "OFFSET" syntax #47

Closed
stevevance opened this issue Aug 16, 2016 · 3 comments
Closed

Update LimitClause doesn't use proper Postgres "OFFSET" syntax #47

stevevance opened this issue Aug 16, 2016 · 3 comments
Assignees
Milestone

Comments

@stevevance
Copy link

Proper Postgres syntax is LIMIT 10 OFFSET 0
This is after updating to v1.10.0

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42601]: Syntax error: 7 ERROR: LIMIT #,# syntax is not supported LINE 10: ) = $1 LIMIT 0 , 10 ^ HINT: Use separate LIMIT and OFFSET clauses.' in /vendor/slim/pdo/src/PDO/Statement/StatementContainer.php:429 Stack trace: #0 /vendor/slim/pdo/src/PDO/Statement/StatementContainer.php(429): PDOStatement->execute(Array) #1 /vendor/slim/pdo/src/PDO/Statement/SelectStatement.php(411): Slim\PDO\Statement\StatementContainer->execute() #2 /user/file.php(382): Slim\PDO\Statement\SelectStatement->execute() #3 /user/file2.php(76): UserFunction() #4 {main} thrown in /vendor/slim/pdo/src/PDO/Statement/StatementContainer.php on line 429
kbaryshnikov added a commit to kbaryshnikov/Slim-PDO that referenced this issue Aug 18, 2016
Use the de-facto standard LIMIT n OFFSET m syntax instead of MySQL-specific LIMIT n,m.
kbaryshnikov added a commit to kbaryshnikov/Slim-PDO that referenced this issue Aug 18, 2016
Use the de-facto standard LIMIT n OFFSET m syntax instead of MySQL-specific LIMIT n,m.
@kbaryshnikov
Copy link

Please see #49

@kwhat kwhat self-assigned this Sep 20, 2019
@kwhat kwhat added this to the v3.0.0 milestone Sep 20, 2019
@kwhat kwhat modified the milestones: v3.0.0, v2.1.0 Dec 18, 2019
@kwhat
Copy link
Collaborator

kwhat commented Dec 18, 2019

Ok, I have created https://github.com/kwhat/PDO-SqlSrv for experimental Microsoft support. I will do the same for Postgres shortly.

@kwhat kwhat mentioned this issue Dec 21, 2019
6 tasks
@kwhat kwhat modified the milestones: v2.1.0, v3.0.0 Oct 29, 2020
@kwhat
Copy link
Collaborator

kwhat commented Nov 2, 2021

This has been updated in 2.2. Postgres to get its own driver in 3.0.

@kwhat kwhat closed this as completed Nov 2, 2021
@kwhat kwhat modified the milestones: v3.0.0, v2.2.0 Nov 2, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants