View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006877 | SymmetricDS | Bug | public | 2025-05-08 20:22 | 2025-05-08 20:57 |
| Reporter | emiller | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | assigned | Resolution | open | ||
| Product Version | 3.13.0 | ||||
| Target Version | 3.16.3 | ||||
| Summary | 0006877: SQL Server DDL reader can cause default values to become invalid by attempting to unescape single quotes | ||||
| Description | After reading a default value from the database metadata for a column with text-based data type, the SQL Server DDL reader unescapes the default value by replacing all instances of 2 consecutive single quotes with 1 single quote. In some cases, this can cause the default value to become invalid. For example, the following default value for a varchar column triggers this bug: coalesce([column_0]+' ','') There are many other DDL readers that run the same code to unescape default values, so this bug is not necessarily limited to the SQL Server DDL reader. | ||||
| Tags | ddl/schema | ||||