[
https://issues.apache.org/jira/browse/CAY-2639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nikita Timofeev updated CAY-2639:
---------------------------------
Fix Version/s: 4.3.M1
(was: 4.2.B2)
> DBImport and DB name case sensitivity
> -------------------------------------
>
> Key: CAY-2639
> URL: https://issues.apache.org/jira/browse/CAY-2639
> Project: Cayenne
> Issue Type: Improvement
> Affects Versions: 4.1.RC2
> Environment: MySQL 5.7
> Reporter: Andrus Adamchik
> Assignee: Nikita Timofeev
> Priority: Minor
> Fix For: 4.3.M1
>
> Time Spent: 1h 20m
> Remaining Estimate: 0h
>
> I just ran into a minor issue with DB import Modeler process.
> Given: A table with lowercase table name and uppercase column names
> 1. DB Import the table to Cayenne. Import preserves correct capitalization.
> 2. Due to a change in project naming conventions, column name capitalization
> was changed to lowercase.
> 3. Rerun DB import.. Result: no changes were reported, and I had to adjust
> the model by hand.
> So DB Import is CS for new names, but is CI when checking for changes.
> The topic of case sensitivity of DB names is not a simple one. There are lots
> of variations and bad legacy. Perhaps here we need to explicitly detect the
> case when a CI check matches a db object (a table or a column), but CS
> reports a pair of events - object deletion and another object creation, and
> present a dialog for the user to decide what to do. Possible options:
> 1. replace the original names (looks like the most reasonable option)
> 2. process as delete/create (the effect is _almost_ the same as #1? except
> some of the obj customizations and possibly relationships may get lost ... is
> this a useful option?)
> 3. Do nothing, effectively preserving the original capitalization (this is
> the current behavior. Do we care to preserve it?)
> Also need to analyze how DB import behaves when multiple tables/columns are
> present that only differ in capitalization (i.e. when it is not a renaming)
> In any event, this issues has a minor impact, as people usually don't
> randomly change name capitalization.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
