[CAY-1484] Flattened attribute queries are incorrectly generated

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.1
• Fix Version/s: 3.0.2, 3.1M1
• Component/s: Core Library
• Environment: Gentoo linux; MySQL 5.1; java version "1.6.0_20"; Java(TM) SE Runtime Environment (build 1.6.0_20-b02); Java HotSpot(TM) 64-Bit Server VM (build 16.3-b01, mixed mode)
• Assignee: Unassigned
• Reporter: Misha Doronin
• Created: 24/Sep/10 14:13
• Updated: 12/Oct/10 11:47
• Resolved: 12/Oct/10 11:47

Description

Attached eclipse project demonstrating issue, including cayenne model
When creating database structure like:
table1
t1key
t1value
t2keyref
table2
t2key
t2value
t3keyref
table3
t3key
t3value
and cayenne model with flattened attribute table3.t3value in table2
it produces incorrect join query to table2 and 3:
SELECT t1.t3value, t1.t2key, t0.t2value, t0.t3keyref, t0.t2key FROM testschema.table2 t0 JOIN testschema.table3 t1 ON (t0.t3key = t1.t3keyref) WHERE t0.t2key = ?

Note t1.t2key, which obviously shouldn't be there and produces error.