Doctrine 2 - ORM
  1. Doctrine 2 - ORM
  2. DDC-726

DQL should deal correctly with composite primary keys

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: DQL
    • Security Level: All
    • Labels:
      None

      Description

      DQL should deal correctly with composite primary keys:

      SELECT u FROM User u WHERE u.CompositeAssocEntity = ?1
      
      Should be converted to:
      
      SELECT ... FROM users u WHERE (u.cae_id1, u.cae_id2) = (?, ?) // or something similar
      

      It also supports IN expressions:

      SELECT u FROM User u WHERE u.CompositeAssocEntity IN (?1, ?2)
      
      Should be converted to:
      
      SELECT ... FROM users u WHERE (u.cae_id1, u.cae_id2) IN ((?, ?), (?, ?)) // or something similar
      

      MySQL, SQLite and PgSQL works smoothly.
      Need to check out MSSQL, Oracle and DB2.

        Issue Links

          Activity

          Guilherme Blanco created issue -
          Guilherme Blanco made changes -
          Field Original Value New Value
          Link This issue is duplicated by DDC-1162 [ DDC-1162 ]
          Benjamin Eberlei made changes -
          Workflow jira [ 11696 ] jira-feedback [ 13868 ]
          Benjamin Eberlei made changes -
          Workflow jira-feedback [ 13868 ] jira-feedback2 [ 15732 ]
          Benjamin Eberlei made changes -
          Workflow jira-feedback2 [ 15732 ] jira-feedback3 [ 17989 ]

          This list may be incomplete, as errors occurred whilst retrieving source from linked applications:

          • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DDC-726, expand=changesets[0:20].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

            People

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

              Dates

              • Created:
                Updated: