View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006876 | SymmetricDS | Bug | public | 2025-05-08 20:16 | 2025-06-08 01:07 |
| Reporter | emiller | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.13.0 | ||||
| Target Version | 3.16.3 | Fixed in Version | 3.16.3 | ||
| Summary | 0006876: SQL Server DDL reader can remove too many outer parentheses from a default value | ||||
| Description | After 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. | ||||
| Tags | ddl/schema | ||||
|
|
PR: https://github.com/JumpMind/symmetric-ds/pull/271 |
|
|
Merged PR: https://github.com/JumpMind/symmetric-ds/pull/271 |
|
|
Included in the 3.16.3 release |
|
SymmetricDS: 3.16 511ef430 2025-05-09 15:31:08 evan-miller-jumpmind Committer: GitHub Details Diff |
0006876: Prevented SQL Server DDL reader from removing too many outer parentheses from a default value (0000271) 0006876: Prevented MS SQL Server DDL reader from removing too many outer parentheses from a complex default value |
Affected Issues 0006876 |
|
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSqlDdlReader.java | Diff File | ||
| 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 | |
| 2025-05-09 15:32 | pbelov | Status | assigned => resolved |
| 2025-05-09 15:32 | pbelov | Resolution | open => fixed |
| 2025-05-09 15:32 | pbelov | Fixed in Version | => 3.16.3 |
| 2025-05-09 15:32 | pbelov | Note Added: 0002952 | |
| 2025-05-09 16:00 | Changeset attached | => SymmetricDS 3.16 511ef430 | |
| 2025-06-08 01:07 | pbelov | Note Added: 0003038 | |
| 2025-06-08 01:07 | pbelov | Status | resolved => closed |