Bug 337297 - Incorrect result (out of foreign key) when combination of complex Primary Key and JOINED Inheritance type
Summary: Incorrect result (out of foreign key) when combination of complex Primary Key...
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P2 major with 1 vote (vote)
Target Milestone: ---   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-02-16 05:59 EST by Piotr Wawrzyniak CLA
Modified: 2022-06-09 10:06 EDT (History)
1 user (show)

See Also:


Attachments
The log file (28.95 KB, text/plain)
2011-02-16 06:03 EST, Piotr Wawrzyniak CLA
no flags Details
The zipped eclipse project (5.31 KB, application/octet-stream)
2011-02-16 06:04 EST, Piotr Wawrzyniak CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Piotr Wawrzyniak CLA 2011-02-16 05:59:24 EST
Build Identifier: 2.1.2.v20101206-r8635

The list of references objects contain entries not matching the foreign key. This occurs when complex primary key containing other entity and
JOINED inheritance is used. Also to enable work in this case (see bug 337293) the duplicated column definition was add in derived classes. For inheritance SINGLE TABLE work fine. As can be see in logs problems probably is cause by not full join (only part of foreign key is used).

Reproducible: Always

Steps to Reproduce:
Steps to Reproduce:
1. Create entity A
2. Create entity Parent with key based on A and int fields
3. Create entity Child with key based on A and int fields and referencing
Parent
4. Create entities ChildX and ChildY extends the Child
5. Add duplicated reference to entity A in ChildX and ChildY
6. Insert data in such structure with the same id and different A.
7. In new run read data from structure

or

1. Create DB using test.sql from the attached project (tested on PostgreSQL
9.0)
2. Run Test class in attached project
3. Rerun the test without the call of create method
Comment 1 Piotr Wawrzyniak CLA 2011-02-16 06:03:36 EST
Created attachment 189085 [details]
The log file
Comment 2 Piotr Wawrzyniak CLA 2011-02-16 06:04:59 EST
Created attachment 189086 [details]
The zipped eclipse project
Comment 3 Tom Ware CLA 2011-02-24 08:31:06 EST
Setting target and priority.  See the following page for the meanings of these fields:

http://wiki.eclipse.org/EclipseLink/Development/Bugs/Guidelines

Community: Please vote for this bug if it is important to you.  Votes are one of the main criteria we use to determine which bugs to fix next.
Comment 4 Eclipse Webmaster CLA 2022-06-09 10:06:23 EDT
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink