Doctrine 2 - ORM

BasicEntityPersister::exists() creates broken SQL with inheritance

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Cannot Reproduce
  • Affects Version/s: 2.2.1
  • Fix Version/s: None
  • Component/s: ORM
  • Security Level: All
  • Labels:
    None
  • Environment:
    FLOW3 Package

Description

The entity persister creates a sql query like SELECT 1 FROM table t0 WHERE t1.id = ?1 when trying to verify a subclass object exists in the database.
This cannot work as t1 from the where clause is not defined. Our particular case was with joined table inheritance.

Attached patch fixes the issue for us.

Issue Links

is duplicated by

Bug - A problem which impairs or prevents the functions of the product. DDC-1841 Problem in the generation QUERY

  • 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
Benjamin Eberlei made changes -
Field Original Value New Value
Link This issue is duplicated by DDC-1841 [ DDC-1841 ]
Benjamin Eberlei made changes -
Workflow jira [ 13631 ] jira-feedback [ 14050 ]
Benjamin Eberlei made changes -
Workflow jira-feedback [ 14050 ] jira-feedback2 [ 15914 ]
Alexander made changes -
Status Open [ 1 ] Awaiting Testcase/Feedback [ 10000 ]
Benjamin Eberlei made changes -
Workflow jira-feedback2 [ 15914 ] jira-feedback3 [ 18206 ]
Benjamin Eberlei made changes -
Status In Progress [ 3 ] Resolved [ 5 ]
Resolution Cannot Reproduce [ 5 ]

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Lienhart Woitok
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: