[CAY-194] Error in generating SQL query in modeling parent child relathionship

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1 [LEGACY]
• Fix Version/s: 1.1 [LEGACY]
• Component/s: Core Library
• Environment: Windows XP java 1.4
• Assignee: Andrus Adamchik
• Reporter: Adrian Popa
• Created: 21/Sep/04 19:37
• Updated: 20/Nov/04 22:01
• Resolved: 20/Nov/04 08:03

Description

I have a table "content" with 2 fields: "id" and "parent_id". "id" is the primary key for the table. I defined a db relationship from "parent_id" to "id" named "toParent". On the content entity I defined a relationship parentContent using the db relationship toParent. When I call getParentContent the generated sql query displayed in the log is something like that:

SELECT DISTINCT t0.ID, t0.PARENT_CONTENT_ID FROM CONTENT t0, CONTENT t1 WHERE t0.ID = t1.PARENT_CONTENT_ID AND ((t0.ID = ?)

but what I would expect would be:

SELECT DISTINCT t0.ID, t0.PARENT_CONTENT_ID FROM CONTENT t0, CONTENT t1 WHERE t0.ID = t1.PARENT_CONTENT_ID AND ((t1.ID = ?)