#1675: DQL: In and Notin expression with two or more operand
------------------------------+---------------------------------------------
Reporter: samueleorso | Owner: guilhermeblanco
Type: enhancement | Status: new
Priority: major | Milestone: Unknown
Component: Query/Hydration | Version: 0.11.0
Resolution: | Keywords:
Has_test: 0 | Mystatus: Pending User Response
Has_patch: 0 |
------------------------------+---------------------------------------------
Changes (by guilhermeblanco):
* mystatus: Pending Core Response => Pending User Response
Comment:
@jwage: DQL parser doesn't support it, but it can be implemented.
@samueleorso: This can be do-able, but I didn't investigate too much to be
100% sure. Although this can be implemented, I need you to tell me how
will it be done.
Imagine I do the query you suggested: SELECT m.* FROM Messages m WHERE
(m.group_id, m.object_id) IN (SELECT uo.group_id, uo.object_id FROM
UserObject uo WHERE uo.user_id = ?)
What will be the generated SQL?
Most DBMS doesn't support this. That's why I am asking you.
Regards,
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1675#comment:2>
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
-~----------~----~----~----~------~----~------~--~---
