#1523: Table alias problem with pagination system and EXISTS query part
------------------------------+---------------------------------------------
Reporter: mm | Owner: romanb
Type: defect | Status: reopened
Priority: critical | Milestone: 1.0.3
Component: Query/Hydration | Version: 1.0.2
Resolution: | Keywords: EXISTS, pager, alias
Has_test: 0 | Mystatus: Pending Core Response
Has_patch: 0 |
------------------------------+---------------------------------------------
Comment (by mm):
Im just after some tests, changeset 5056 helps (partly) with EXISTS part
mapping, but still its not all.
{{{
SELECT "t"."id" AS "t__id", "t"."code" AS "t__code", "t"."name" AS
"t__name"
FROM "tow" "t"
LEFT JOIN "zam" "z" ON "t"."id" = "z"."tow_id"
WHERE "t"."id"
IN (SELECT "doctrine_subquery_alias"."id" FROM
(
SELECT DISTINCT "t2"."id", "t2"."name"
FROM "tow" "t2"
LEFT JOIN "zam" "z2" ON "t2"."id" = "z2"."tow_id" WHERE
EXISTS (
SELECT "t3"."id" AS "t3__id" FROM "tow" "t3" WHERE
("t3"."removed" = 'f' AND "t3"."id" = "t2"."id"))
ORDER BY "t2"."name" ASC LIMIT 30
) AS doctrine_subquery_alias) AND
EXISTS (SELECT "t2"."id" AS "t2__id" FROM "tow" "t2" WHERE ("t2"."removed"
= 'f' AND "t2"."id" = "t"."id"))
ORDER BY "t"."name" ASC
}}}
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1523#comment:5>
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
-~----------~----~----~----~------~----~------~--~---
