Doctrine 2 - ORM
  1. Doctrine 2 - ORM
  2. DDC-1225

Invalid SQL generated (extra comma) when joining to entity with composite PK

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: 2.1
    • Fix Version/s: 2.1.2, 2.2
    • Component/s: ORM
    • Security Level: All
    • Labels:
      None

      Description

                  $qb->from('Tournaments_Model_StageBracketTeamRegistration', 'r')
                     ->innerJoin('r.teamSelection', 'ts')
                     ->innerJoin('ts.players', 'tsp')
                     ->select('r, ts, tsp')
                     ->where('r.stageBracket = ?1')
                     ->andWhere('r.opponentIsReserve = false')
                     ->orderBy('r.registrationDateTime')
                     ->setParameter(1, $bracket);

      Generates:

      SELECT s0_.id AS id0, s0_.opponent_is_reserve AS opponent_is_reserve1, s0_.opponent_checked_in AS opponent_checked_in2, s0_.registration_date_time AS registration_date_time3, t1_.id AS id4,, s0_.type AS type5, s0_.stage_bracket_id AS stage_bracket_id6, s2_.team_selection_id AS team_selection_id7, t1_.team_id AS team_id8, t3_.team_selection_id AS team_selection_id9, t3_.player_id AS player_id10
      FROM stage_bracket_team_registrations s2_
      INNER JOIN stage_bracket_registrations s0_ ON s2_.id = s0_.id
      INNER JOIN team_selections t1_ ON s2_.team_selection_id = t1_.id
      INNER JOIN team_selection_players t3_ ON t1_.id = t3_.team_selection_id
      WHERE s0_.stage_bracket_id = 22 AND s0_.opponent_is_reserve = 0
      ORDER BY s0_.registration_date_time ASC

      Note the 2nd comma after "t1_.id AS id4". TeamSelectionPlayer uses a composite PK. I have attached the relevant entity classes.

        Activity

          People

          • Assignee:
            Guilherme Blanco
            Reporter:
            Glen Ainscow
          • Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: