DDC-1621: Add support for FROM Class1 a1 JOIN Class2 a2 WITH cond queries #2262

Closed
doctrinebot opened this Issue Jan 25, 2012 · 3 comments

2 participants

@doctrinebot

Jira issue originally created by user @beberlei:

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

@doctrinebot

Comment created by alex00888:

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.

@doctrinebot

Comment created by @ocramius:

Was already solved in 2.3.x

@doctrinebot

Issue was closed with resolution "Fixed"

@asm89 asm89 was assigned by doctrinebot Dec 6, 2015
@doctrinebot doctrinebot added this to the 2.3 milestone Dec 6, 2015
@doctrinebot doctrinebot closed this Dec 6, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment