[
https://issues.apache.org/jira/browse/CAY-2975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrus Adamchik closed CAY-2975.
--------------------------------
Resolution: Fixed
> Mnemonic table aliases in generated SQL
> ---------------------------------------
>
> Key: CAY-2975
> URL: https://issues.apache.org/jira/browse/CAY-2975
> Project: Cayenne
> Issue Type: Task
> Reporter: Andrus Adamchik
> Assignee: Andrus Adamchik
> Priority: Minor
> Fix For: 5.0-M3
>
>
> When Cayenne does query to SQL translation, it assigns table aliases like t0,
> t1, t2, etc. This is simple to implement, but makes queries less
> readable. Let's do a few alias enhacements:
> 1. When only one table is present in the query, don't use table aliases at all
> 2. When multiple tables are in use, let's generate more recognizable aliases.
> Here is one idea: assume table names are "snake case", and generate aliases
> using the first letter of each name part ("user_role" would become "ur").
> Cache precalucalted aliases inside DbEntity. If there is a conflict between
> aliases within a query, then use numeric ids. (So the second "ur" would
> become "ur1", third - "ur2", etc.)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
