2 namespace Doctrine\Tests\ORM\Functional\Ticket;
4 require_once __DIR__ . '/../../../TestInit.php';
6 class DDC448Test extends \Doctrine\Tests\OrmFunctionalTestCase
8 protected function setUp()
11 $this->_schemaTool->createSchema(array(
12 $this->_em->getClassMetadata(__NAMESPACE__ . '\DDC448MainTable'),
13 $this->_em->getClassMetadata(__NAMESPACE__ . '\DDC448ConnectedClass'),
14 $this->_em->getClassMetadata(__NAMESPACE__ . '\DDC448SubTable'),
18 public function testIssue()
20 $q = $this->_em->createQuery("select b from ".__NAMESPACE__."\\DDC448SubTable b where b.connectedClassId = ?1");
22 strtolower('SELECT d0_.id AS id0, d0_.discr AS discr1, d0_.connectedClassId AS connectedClassId2 FROM SubTable s1_ INNER JOIN DDC448MainTable d0_ ON s1_.id = d0_.id WHERE d0_.connectedClassId = ?'),
23 strtolower($q->getSQL())
30 * @InheritanceType("JOINED")
31 * @DiscriminatorColumn(name="discr", type="smallint")
33 * "0" = "DDC448MainTable",
34 * "1" = "DDC448SubTable"
41 * @Column(name="id", type="integer")
42 * @GeneratedValue(strategy="AUTO")
47 * @ManyToOne(targetEntity="DDC448ConnectedClass", cascade={"all"}, fetch="EAGER")
48 * @JoinColumn(name="connectedClassId", referencedColumnName="id", onDelete="CASCADE", nullable=true)
50 private $connectedClassId;
55 * @Table(name="connectedClass")
56 * @HasLifecycleCallbacks
58 class DDC448ConnectedClass
62 * @Column(name="id", type="integer")
63 * @GeneratedValue(strategy="AUTO")
65 protected $id; // connected with DDC448MainTable
70 * @Table(name="SubTable")
72 class DDC448SubTable extends DDC448MainTable