[TORQUE-10] doSelectJoinYYY in Oracle fails with limit/offset and same column names

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2
• Fix Version/s: 3.3
• Component/s: Runtime
• Environment: Oracle
• Old Scarab Id: TRQS295
• Assignee: Thomas Fox
• Reporter: Thomas Fox
• Created: 01/May/06 22:40
• Updated: 26/Nov/06 18:23
• Resolved: 17/Oct/06 06:58

Description

Reported by Bouvet Konsulent: If a criteria with a limit or Offset is used in XXXPeer.doSelectJoinYYY(Criteria), and the Tables XXX and YYY have columns with same names, the method fails with a ORA-00918: column ambiguously defined.
This is because the "select *" from the limit/offset query clashes with the two same names in the inner select clause.