Doctrine 2 - ORM

Add support for FROM Class1 a1 JOIN Class2 a2 WITH cond queries

Details

  • Type: New Feature New Feature
  • Status: In Progress In Progress
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: None
  • Fix Version/s: 2.4
  • Component/s: None
  • Security Level: All
  • Labels:
    None

Description

Check feasibility of this kind of query different from FROM Class1 a1, Class2 a2 to allow arbitrary joins between classes.

Activity

Ascending order - Click to sort in descending order
Benjamin Eberlei made changes -
Field Original Value New Value
Workflow jira [ 13390 ] jira-feedback [ 14015 ]
Benjamin Eberlei made changes -
Workflow jira-feedback [ 14015 ] jira-feedback2 [ 15879 ]
Benjamin Eberlei made changes -
Workflow jira-feedback2 [ 15879 ] jira-feedback3 [ 18135 ]
Benjamin Eberlei made changes -
Fix Version/s 2.4 [ 10321 ]
Fix Version/s 2.3 [ 10185 ]
Hide
Permalink
Alex added a comment -

Hi all!
Maybe if this task is hard, you could do a simplier variant, "FROM Class1 a1 JOIN a1,a2 WITH a2 INSTANCE OF Class2"?
Doctrine 2.3 supports it, but in fact, it does not work. I can't use Class2 fields in query, and Doctrine ignores the INSTANCE OF operator when building a native queries.
I am working with system where I have many inherited classes with Class Table Inheritance. When I do a JOIN query, it generates native sql query more than 1KB(?!) length, and MySQL freezes for more than 7 minutes (?!) on it. It must join only tables for Class2, but it joins all my 20 tables inherited of my base class
I don't know where to send bugreport
It will be very good if I could manually select a joined class to make Doctrine do a better queries.
Sorry for my english, I am from Moscow.

Show
Alex added a comment - Hi all! Maybe if this task is hard, you could do a simplier variant, "FROM Class1 a1 JOIN a1,a2 WITH a2 INSTANCE OF Class2"? Doctrine 2.3 supports it, but in fact, it does not work. I can't use Class2 fields in query, and Doctrine ignores the INSTANCE OF operator when building a native queries. I am working with system where I have many inherited classes with Class Table Inheritance. When I do a JOIN query, it generates native sql query more than 1KB(?!) length, and MySQL freezes for more than 7 minutes (?!) on it. It must join only tables for Class2, but it joins all my 20 tables inherited of my base class I don't know where to send bugreport It will be very good if I could manually select a joined class to make Doctrine do a better queries. Sorry for my english, I am from Moscow.
Alex made changes -
Status Open [ 1 ] Awaiting Feedback [ 10000 ]
Alex made changes -
Status Awaiting Feedback [ 10000 ] In Progress [ 3 ]
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-1621, expand=changesets[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

People

  • Assignee:
    Alexander
    Reporter:
    Benjamin Eberlei
Vote (1)
Watch (2)

Dates

  • Created:
    Updated: