tracker issue : CF-4148154

select a category, or use search below
(searches all categories and all time range)
Title:

ORM inheritance working incorrectly

| View in Tracker

Status/Resolution/Reason: To Track//ThirdParty

Reporter/Name(from Bugbase): Geoffrey Demoulin / Geoffrey Demoulin (Geoffrey Demoulin)

Created: 05/03/2016

Components: ORM Support

Versions: 2016,11.0,2018

Failure Type: Crash

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Windows 8.1/64bit

Vote Count: 0

Problem Description:

Using entity inheritance causes incorrect SQL statements to be generated by coldfusion.

I have the following structure:

The Company component has offices. The Office component inherits Entity.

Steps to Reproduce:

Use the attached project.

Actual Result:

* An exception is thrown: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'companyId'.
* coldfusion-out.log shows:
    select
        offices0_.companyId as companyId0_1_,
        offices0_.id as id1_1_,
        offices0_.id as id1_0_,
        offices0_1_.name as name2_0_,
        offices0_1_.companyId as companyId2_0_ 
    from
        Entity offices0_ 
    inner join
        Office offices0_1_ 
            on offices0_.id=offices0_1_.id 
    where
        offices0_.companyId=?

  -> Coldfusion ORM is trying to discriminate on Entity.companyId which doesn't exist (it's part of the Office component)!!


Expected Result:

No error, Companies have an array of Offices.

Any Workarounds:
No workaround found.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4148154

External Customer Info:
External Company:  
External Customer Name: Geoffrey Demoulin
External Customer Email:  
External Test Config: My Hardware and Environment details:

Coldfusion 11u6 (u7 has a blocking bug for my environment)

Attachments:

  1. May 04, 2016 00:00:00: 1_ORM_INHERITANCE.zip

Comments: