View Issue Details

IDProjectCategoryView StatusLast Update
0006876SymmetricDSBugpublic2025-05-08 20:46
Reporteremiller Assigned Toemiller  
Prioritynormal 
Status assignedResolutionopen 
Product Version3.13.0 
Target Version3.16.3 
Summary0006876: SQL Server DDL reader can remove too many outer parentheses from a default value
DescriptionAfter reading a default value from the database metadata, the SQL Server DDL reader removes outer parentheses that enclose the default value. In some cases, it remove too many outer parentheses, causing the default value to become invalid. For example, the following default value triggers this bug:

((coalesce([column_0]+' ',''))+coalesce([column_1]+' ',''))

There are several other places that use this same approach to remove outer parentheses, so this bug is not necessarily limited to the SQL Server DDL reader.
Tagsddl/schema

Activities

Issue History

Date Modified Username Field Change
2025-05-08 20:16 emiller New Issue
2025-05-08 20:16 emiller Status new => assigned
2025-05-08 20:16 emiller Assigned To => emiller
2025-05-08 20:16 emiller Tag Attached: ddl/schema
2025-05-08 20:46 emiller Note Added: 0002948