Uploaded image for project: 'Doctrine 1'
  1. Doctrine 1
  2. DC-347

AddPendingJoinConditions doesn't work if alias equals model name

    Details

    • Type: Bug
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 1.2.1
    • Fix Version/s: None
    • Component/s: Query
    • Labels:
      None

      Description

      If the alias in a from-query is equal to the model name, I get an exception when executing the query after adding a "pendingJoinCondition".

      See attached testCase.

        Activity

        Hide
        jensen83 Christian Jaentsch added a comment -

        To clarify again: Using an alias equal to the model name is the same as not using an alias at all. The built sql is the same afterwards (and the addPendingJoinCondition behaviour is the same as well).

        I would not use an alias equal to the model name myself, but sometimes this is used in Doctrine core, e.g. in Doctrine_Relation_ForeignKey around line 60. So to solve the problem either all the core queries, where no alias or an alias equal to the model name is used, have to be rewritten or the behaviour of a respective query has to be changed somehow so that applying an addPendingJoinCondition is possible even in the given case.

        Show
        jensen83 Christian Jaentsch added a comment - To clarify again: Using an alias equal to the model name is the same as not using an alias at all. The built sql is the same afterwards (and the addPendingJoinCondition behaviour is the same as well). I would not use an alias equal to the model name myself, but sometimes this is used in Doctrine core, e.g. in Doctrine_Relation_ForeignKey around line 60. So to solve the problem either all the core queries, where no alias or an alias equal to the model name is used, have to be rewritten or the behaviour of a respective query has to be changed somehow so that applying an addPendingJoinCondition is possible even in the given case.
        Hide
        hobodave David Abdemoulaie added a comment -

        I fail to see why you would use an alias that is equal to the model name.

        Show
        hobodave David Abdemoulaie added a comment - I fail to see why you would use an alias that is equal to the model name.

          People

          • Assignee:
            guilhermeblanco Guilherme Blanco
            Reporter:
            jensen83 Christian Jaentsch
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated: