Doctrine 2 - ORM

DQL should deal correctly with composite primary keys

Details

  • Type: Improvement Improvement
  • Status: Open 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

is duplicated by

New Feature - A new feature of the product, which has yet to be developed. DDC-1162 Add support for multi-column IN statements

  • Major - Major loss of function.
  • Resolved - A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.

Activity

Ascending order - Click to sort in descending order
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[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

People

  • Assignee:
    Guilherme Blanco
    Reporter:
    Guilherme Blanco
Vote (1)
Watch (1)

Dates

  • Created:
    Updated: