Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 329251

Summary: Feature Request: EclipseLink to optionally use full table names for table aliases in SQL not just T0, T1, T2
Product: z_Archived Reporter: Igor Mukhin <iimuhin>
Component: EclipselinkAssignee: Nobody - feel free to take it <nobody>
Status: NEW --- QA Contact:
Severity: enhancement    
Priority: P3 CC: iimuhin, tom.ware
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
Whiteboard:

Description Igor Mukhin CLA 2010-11-02 07:36:05 EDT 
Build Identifier: 2.1.0

EclipseLink normally generates SQLs like:
SELECT t0.ID, t1.NAME FROM MAN t0, WIFE t1 WHERE t0.ID = t1.MAN_ID

Now it is not possible to tell EclipseLink, that it should use full table names for aliases to make the query more readable?
SELECT t0_MAN.ID, t1_WIFE.NAME FROM MAN t0_MAN, WIFE t1_WIFE WHERE t0_MAN.ID = t1_WIFE.MAN_ID

I think Hibernate has a similar feature.
It would be nice to have this feature in EclipseLink.

see http://stackoverflow.com/questions/4024931/how-to-tell-eclipselink-to-use-full-table-names-for-aliases-in-sql/4033532

Reproducible: Always

Steps to Reproduce:
no
Comment 1 Eclipse Webmaster CLA 2022-06-09 10:32:41 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink