I don't think your change is the right change and you don't really give any good information in your ticket like the error that occurs, or anything else, etc...please try and be as descriptive as possible, include exception messages, stack traces, code to produce the problem and your changes should be submitted as a patch.

stack trace from failed join

I agree that change isn't the right fix, it's a kludge that makes Oracle work, probably at the expense of databases that obey case in names. I've reproduced the problem with a small example. The database has two tables PKW_PARENT and PKW_CHILD. The schema.yml is

PkwParent:
  tableName: PKW_PARENT
  columns:
    parent_id:
      type: integer(2147483647)
      primary: true
    name: string(20)
  relations:
    PkwChild:
      local: PARENT_ID
      foreign: PARENT_ID
      type: one

PkwChild:
  tableName: PKW_CHILD
  columns:
    child_id:
      type: integer(2147483647)
      primary: true
    child_name: string(20)
    parent_id: integer(2147483647)
  relations:
    PkwParent:
      local: PARENT_ID
      foreign: PARENT_ID
      type: many

This was built from the database using

symfony doctrine:build-schema

Note that the column names are lower case in the tables, but upper case in the relations, the kludge fixes this. When I attempt to join these tables I get

Unknown property PARENT_ID
    * at ()
      in SF_SYMFONY_LIB_DIR\plugins\sfDoctrinePlugin\lib\vendor\doctrine\Doctrine\Record.php line 944 ...

I've included the stack trace as an attachment. Now that I have a simple example I'll see if I can find a better fix. /peter

look at the ticket #2332

this problem is due to a bad definition or relations in the schema.yml file.

relation child->parent should be many to one and not the contrary.

JR

I think this should be fixed now. It was fixed indirectly by another ticket.