DDC-3831: [GH-1463] Fixed issue when paginator orders by a subselect expression #4692

New Issue

admin · 2026-01-22T14:47:44+01:00

admin commented

2026-01-22 14:47:44 +01:00

Originally created by @doctrinebot on GitHub (Jul 16, 2015).

Jira issue originally created by user @doctrinebot:

This issue is created automatically through a Github pull request on behalf of ehimen:

Url: https://github.com/doctrine/doctrine2/pull/1463

Message:

On platforms that support the ROW_NUMBER() OVER() function, we've found issues when ordering by a subselect expression. Have included a test demonstrating the problem that was failing with a syntax error under Postgres:

Caused by
PDOException: SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "SELECT"
LINE 1: ...d = c0*.id) AS sclr_4, ROW*NUMBER() OVER(ORDER BY SELECT MAX...

Originally created by @doctrinebot on GitHub (Jul 16, 2015). Jira issue originally created by user @doctrinebot: This issue is created automatically through a Github pull request on behalf of ehimen: Url: https://github.com/doctrine/doctrine2/pull/1463 Message: On platforms that support the ROW_NUMBER() OVER() function, we've found issues when ordering by a subselect expression. Have included a test demonstrating the problem that was failing with a syntax error under Postgres: ``` Caused by PDOException: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "SELECT" LINE 1: ...d = c0*.id) AS sclr_4, ROW*NUMBER() OVER(ORDER BY SELECT MAX... ```

admin added the Bug label 2026-01-22 14:47:44 +01:00

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#4692