doctrine/archived-orm
1
0
Fork 0
mirror of https://github.com/doctrine/orm.git synced 2026-03-23 22:42:18 +01:00
Code Issues 5.3k Packages Projects Releases 100 Wiki Activity

DDC-1795: Bug in generation sql when using join on extended entity #2258

New Issue
Open
opened 2026-01-22 13:46:30 +01:00 by admin · 0 comments
admin commented 2026-01-22 13:46:30 +01:00
Owner
Copy Link

Originally created by @doctrinebot on GitHub (Apr 24, 2012).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user alimovalisher@gmail.com:

I have several entities:
*Client
*Payment
*PaymentDeposit
*PaymentWithdraw

PaymentDeposit and PaymentWithdraw extends from entity Payment

Here is the code


/****
 * @ORM\Entity
 * @ORM\Table(name="client")
 */
class Client 
{
   /****
     * @var int $id
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $id;

    /****
     * @var ArrayCollection
     * @ORM\OneToMany(targetEntity="PaymentDeposit", mappedBy="clientTo")
     */
    private $depositPayments;

    /****
     * @var ArrayCollection
     * @ORM\OneToMany(targetEntity="PaymentWithdraw", mappedBy="clientFrom")
     */
    private $withdrawPayments;

}



/****
 * @ORM\Entity
 * @ORM\Table(name="payment")
 * @ORM\InheritanceType("JOINED")
 * @ORM\DiscriminatorColumn(name="type", type="smallint")
 * @ORM\DiscriminatorMap({
 *                        1 = "PaymentDeposit",
 *                        2 = "PaymentWithdraw"})
 */
class Transaction 
{
    /****
     * @var int $id
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $id;

    /****
     * @var float
     * @ORM\Column(name="amount", type="decimal", precision=15, scale=5)
     */
    protected $amount;

    /****
     * @var Client
     * @ORM\ManyToOne(targetEntity="Client", inversedBy="withdrawPayments")
     * @ORM\JoinColumn(name="client_from", referencedColumnName="id", onDelete="cascade")
     */
    protected $clientFrom;

    /****
     * @var Client
     * @ORM\ManyToOne(targetEntity="Client",inversedBy="depositPayments")
     * @ORM\JoinColumn(name="client_to", referencedColumnName="id", onDelete="cascade")
     */
    protected $clientTo;

    /****
     * @var int
     * @ORM\Column(type="smallint")
     */
    protected $status;
}   


/****
 * @ORM\Entity
 * @ORM\Table(name="payment_deposit")
 */
class PaymentDeposit extends Transaction
{
    // Additional info
}

/****
 * @ORM\Entity
 * @ORM\Table(name="payment_deposit")
 */
class PaymentWithdraw extends Transaction
{
    // Additional info
}

When I try to get result with such query I got sql error

$queryBuilder = $this->getEntityManager()->createQueryBuilder();

$queryBuilder->select('c')
            ->from('Client', 'c')
            ->leftJoin('c.depositPayments', 'd')
            ->leftJoin('c.withdrawPayments', 'w')
            ->andWhere($queryBuilder->expr()->eq('d.status', ':status'))
            ->andWhere($queryBuilder->expr()->eq('w.status', ':status'));

sql error:
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't2_.client_to' in 'on clause' (uncaught exception) at project/vendor/doctrine-dbal/lib/Doctrine/DBAL/Connection.php line 628

native sql query(generated)

SELECT c1_.id,  -- other columns
FROM client c1_ 
LEFT JOIN payment*deposit t2_ ON c1_.id = t2_.client*to 
LEFT JOIN payment t3* ON t2_.id = t3*.id 
LEFT JOIN payment*withdraw t4_ ON c1_.id = t4_.client*from 
LEFT JOIN payment t5* ON t4_.id = t5*.id 
WHERE  t3*.transaction_status_id = 1 AND t5_.transaction_status*id = 1

Problem is here

LEFT JOIN payment*deposit t2_ ON c1_.id = t2_.client*to 
LEFT JOIN payment*withdraw t4_ ON c1_.id = t4_.client*from

extended Entities PaymentDeposit, PaymentWithdraw (tables) doesnt have field clientFrom & clientTo they extend them from entity Payment

P.S. I removed unnecessary fields from Entities to make code example more clearly

Originally created by @doctrinebot on GitHub (Apr 24, 2012). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user alimovalisher@gmail.com: I have several entities: *Client *Payment *PaymentDeposit *PaymentWithdraw PaymentDeposit and PaymentWithdraw extends from entity Payment Here is the code ``` /**** * @ORM\Entity * @ORM\Table(name="client") */ class Client { /**** * @var int $id * @ORM\Id * @ORM\Column(type="integer") * @ORM\GeneratedValue(strategy="AUTO") */ protected $id; /**** * @var ArrayCollection * @ORM\OneToMany(targetEntity="PaymentDeposit", mappedBy="clientTo") */ private $depositPayments; /**** * @var ArrayCollection * @ORM\OneToMany(targetEntity="PaymentWithdraw", mappedBy="clientFrom") */ private $withdrawPayments; } /**** * @ORM\Entity * @ORM\Table(name="payment") * @ORM\InheritanceType("JOINED") * @ORM\DiscriminatorColumn(name="type", type="smallint") * @ORM\DiscriminatorMap({ * 1 = "PaymentDeposit", * 2 = "PaymentWithdraw"}) */ class Transaction { /**** * @var int $id * @ORM\Id * @ORM\Column(type="integer") * @ORM\GeneratedValue(strategy="AUTO") */ protected $id; /**** * @var float * @ORM\Column(name="amount", type="decimal", precision=15, scale=5) */ protected $amount; /**** * @var Client * @ORM\ManyToOne(targetEntity="Client", inversedBy="withdrawPayments") * @ORM\JoinColumn(name="client_from", referencedColumnName="id", onDelete="cascade") */ protected $clientFrom; /**** * @var Client * @ORM\ManyToOne(targetEntity="Client",inversedBy="depositPayments") * @ORM\JoinColumn(name="client_to", referencedColumnName="id", onDelete="cascade") */ protected $clientTo; /**** * @var int * @ORM\Column(type="smallint") */ protected $status; } /**** * @ORM\Entity * @ORM\Table(name="payment_deposit") */ class PaymentDeposit extends Transaction { // Additional info } /**** * @ORM\Entity * @ORM\Table(name="payment_deposit") */ class PaymentWithdraw extends Transaction { // Additional info } ``` When I try to get result with such query I got sql error ``` $queryBuilder = $this->getEntityManager()->createQueryBuilder(); $queryBuilder->select('c') ->from('Client', 'c') ->leftJoin('c.depositPayments', 'd') ->leftJoin('c.withdrawPayments', 'w') ->andWhere($queryBuilder->expr()->eq('d.status', ':status')) ->andWhere($queryBuilder->expr()->eq('w.status', ':status')); ``` sql error: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't2_.client_to' in 'on clause' (uncaught exception) at project/vendor/doctrine-dbal/lib/Doctrine/DBAL/Connection.php line 628 native sql query(generated) ``` SELECT c1_.id, -- other columns FROM client c1_ LEFT JOIN payment*deposit t2_ ON c1_.id = t2_.client*to LEFT JOIN payment t3* ON t2_.id = t3*.id LEFT JOIN payment*withdraw t4_ ON c1_.id = t4_.client*from LEFT JOIN payment t5* ON t4_.id = t5*.id WHERE t3*.transaction_status_id = 1 AND t5_.transaction_status*id = 1 ``` Problem is here ``` LEFT JOIN payment*deposit t2_ ON c1_.id = t2_.client*to LEFT JOIN payment*withdraw t4_ ON c1_.id = t4_.client*from ``` extended Entities PaymentDeposit, PaymentWithdraw (tables) doesnt have field clientFrom & clientTo they extend them from entity Payment P.S. I removed unnecessary fields from Entities to make code example more clearly
admin added the Bug label 2026-01-22 13:46:30 +01:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
BC Break
Bug
Can't Fix
Deprecation
Documentation
DQL
Duplicate
Failing Test
Hacktoberfest
Improvement
Improvement
Incomplete
Invalid
Missing Tests
New Feature
PR Created
pull-request
Mirrored from GitHub Pull Request
 Question
Regression
Status: Waiting feedback
Waiting feedback
WIP
Won't Fix
No Label Bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
admin
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#2258
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?