View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006689 | SymmetricDS | Bug | public | 2025-01-03 16:08 | 2025-01-03 20:06 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.11 | ||||
| Target Version | 3.15.12 | Fixed in Version | 3.15.12 | ||
| Summary | 0006689: Postgres negative default values always show as changed | ||||
| Description | When the default value for a numeric column is set to a negative value, the postgres ddl reader always reads a value as follows: '-1'::integer This value is compared to the target value of: -1 They are always different, and our ModelComparator always executes an alter to change the default value. Currently, the only table with negative default values is sym_compare_request. | ||||
| Steps To Reproduce | 1. Configure database connection to Postgres. 2. Restart instance, and observe logging for changing tables and the alters that are executed. | ||||
| Tags | ddl/schema, dialect: postgresql | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-01-03 16:08 | pmarzullo | New Issue | |
| 2025-01-03 16:08 | pmarzullo | Status | new => assigned |
| 2025-01-03 16:08 | pmarzullo | Assigned To | => pmarzullo |
| 2025-01-03 16:08 | pmarzullo | Tag Attached: ddl/schema | |
| 2025-01-03 16:08 | pmarzullo | Tag Attached: dialect: postgresql | |
| 2025-01-03 16:36 | pmarzullo | Status | assigned => resolved |
| 2025-01-03 16:36 | pmarzullo | Resolution | open => fixed |
| 2025-01-03 16:36 | pmarzullo | Fixed in Version | => 3.15.13 |
| 2025-01-03 17:00 | pmarzullo | Changeset attached | => SymmetricDS 3.15 977e3cc5 |
| 2025-01-03 19:07 | pmarzullo | Product Version | 3.15.12 => 3.15.11 |
| 2025-01-03 19:07 | pmarzullo | Target Version | 3.15.13 => 3.15.12 |
| 2025-01-03 19:28 | pbelov | Fixed in Version | 3.15.13 => 3.15.12 |
| 2025-01-03 20:06 | pbelov | Note Added: 0002572 | |
| 2025-01-03 20:06 | pbelov | Status | resolved => closed |