#1365: Wrong SQL statement with enums
------------------------------+---------------------------------------------
Reporter: clx | Owner: romanb
Type: defect | Status: closed
Priority: minor | Milestone: 1.0.0-RC2
Component: Query/Hydration | Version: 1.0
Resolution: invalid | Keywords:
Has_test: 0 | Mystatus: Pending Core Response
Has_patch: 0 |
------------------------------+---------------------------------------------
Changes (by guilhermeblanco):
* status: new => closed
* resolution: => invalid
Comment:
In r4835 I added coverage to this issue.
This ticket is invalid and here is the explanation: Your record is
invalid.
1) You are defining a MN relation object with columns inside of it. You
should either remove the columns or remove the primary keys inclusion on
fk columns.
2) Your columns are wrongly defined. you set "hasColumn('value0, 'enum'
...)", and forget to close the quote. This happened twice (value0 and
value1), which caused at the end in a couple ', then PHP not reporting any
issue.
Here is another suggestion. If you leftJoin an Object and then add a where
clause using fields of the joined object, it'll be the same as an
innerJoin. So... you should either use innerJoin or define the WITH inside
leftJoin, like this:
->leftJoin('s.PersonHasSkill phs WITH phs.value0 > phs.value1')
I hope it helps.
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1365#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
-~----------~----~----~----~------~----~------~--~---
