#1416: ORDER BY and LIMIT on pgsql Doctrine_Query
-----------------------------------+----------------------------------------
Reporter: j.debowczyk | Owner: jwage
Type: defect | Status: new
Priority: major | Milestone: New
Component: Attributes | Version: 0.11
Keywords: postgrsql limit query | Has_test: 0
Mystatus: Pending Core Response | Has_patch: 0
-----------------------------------+----------------------------------------
There is workaround on pgsql "SELECT DISTINCT * LIMIT" limitation in
Doctrine_Query::getLimitSubquery() method. The limitation means you cannot
execute in PostgreSQL query "SELECT DISTINCT id FROM table ORDER BY col1
LIMIT 5" - order by columns must be specified after SELECT. In this place,
Doctrine builds query "SELECT DISTINCT id, col1 FROM table ORDER BY col1
LIMIT 5" which, of course, is not compatible with first.
This manner is especially obstructing when you use pager with two-level
order by query.
--
Ticket URL: <http://trac.phpdoctrine.org/ticket/1416>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"doctrine-svn" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.co.uk/group/doctrine-svn?hl=en-GB
-~----------~----~----~----~------~----~------~--~---
