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
Hide
Permalink
Benjamin Eberlei added a comment -

I can't reproduce this. Can you provide the mapping details?

Show
Benjamin Eberlei added a comment - I can't reproduce this. Can you provide the mapping details?
Hide
Permalink
Benjamin Eberlei added a comment -

Cannot reproduce and no feedback given.

Show
Benjamin Eberlei added a comment - Cannot reproduce and no feedback given.

People

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

Dates

  • Created:
    Updated:
    Resolved: