Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 329251 - Feature Request: EclipseLink to optionally use full table names for table aliases in SQL not just T0, T1, T2
Summary: Feature Request: EclipseLink to optionally use full table names for table ali...
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows 7
: P3 enhancement with 2 votes (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-11-02 07:36 EDT by Igor Mukhin CLA
Modified: 2022-06-09 10:32 EDT (History)
2 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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