View Issue Details

IDProjectCategoryView StatusLast Update
0003479SymmetricDSBugpublic2022-08-05 16:20
Reporternrichardson Assigned Toelong  
Prioritynormal 
Status acknowledgedResolutionopen 
Product Version3.9.0 
Summary0003479: Locate the catalog/schema regardless of the case when data loading
DescriptionDepending on the database settings, sometimes catalog/schema names are case specific. This would enable Symmetric to locate the catalog/schema regardless of the case use in the configuration.
Tagsconfiguration, ddl/schema

Relationships

related to 0000710 new sym_trigger.source_catalog_name and sym_trigger.source_schema_name should respect db.metadata.ignore.case 
related to 0002248 new Syncing H2 and postgres creates problem when source schema is given (case sensitivity) 

Activities

elong

2019-04-24 17:39

developer   ~0001433

Was there a specific database you found this on that we can test with to reproduce the problem? I think I've seen people mention the problem using H2.

admin

2019-05-09 14:56

administrator   ~0001455

SQL-Server can have case sensitive catalog/schema. Probably H2 also.

Issue History

Date Modified Username Field Change
2018-03-07 15:12 nrichardson New Issue
2019-04-24 17:37 elong Tag Attached: ddl/schema
2019-04-24 17:37 elong Tag Attached: configuration
2019-04-24 17:39 elong Assigned To => elong
2019-04-24 17:39 elong Status new => feedback
2019-04-24 17:39 elong Note Added: 0001433
2019-05-09 14:56 admin Status feedback => acknowledged
2019-05-09 14:56 admin Note Added: 0001455
2019-05-09 14:56 admin Summary Locate the catalog/schema regardless of the case => Locate the catalog/schema regardless of the case when data loading
2019-05-09 15:14 elong Relationship added related to 0000710
2019-05-14 12:21 elong Category Improvement => Bug
2022-08-05 16:20 elong Relationship added related to 0002248