View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007083 | SymmetricDS | Bug | public | 2025-09-29 19:04 | 2025-10-03 22:47 |
| Reporter | emiller | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.16.7 | Fixed in Version | 3.16.7 | ||
| Summary | 0007083: When sending a table schema containing a LONGVARBINARY column to an H2 2.x node, the table always gets rebuilt | ||||
| Description | When sending a table schema containing a LONGVARBINARY column to an H2 2.x node, the table always gets rebuilt because the model comparator detects a type code difference. This is because the metadata indicates that the column is a VARBINARY with a size of 1000000000, which doesn't match the XML. The following message appears in the log before the table gets rebuilt: 2025-09-29 14:53:22,812 INFO [client] [ModelComparator] [client-dataloader-10] The [column name] column on the [table name] table changed type codes from -3 to -4 | ||||
| Tags | ddl/schema, dialect: h2 | ||||
|
|
Merged PR: https://github.com/jumpmindinc/symmetric-ds/pull/398 |
|
|
Cherry-picked to 3.17: https://github.com/jumpmindinc/symmetric-ds/commit/2070cdad1681f5b3ad1a1853eb10fc1a74226bd9 |
|
|
Included in the 3.16.7 release |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-09-29 19:04 | emiller | New Issue | |
| 2025-09-29 19:04 | emiller | Status | new => assigned |
| 2025-09-29 19:04 | emiller | Assigned To | => emiller |
| 2025-09-29 19:04 | emiller | Tag Attached: ddl/schema | |
| 2025-09-29 19:04 | emiller | Tag Attached: dialect: h2 | |
| 2025-09-29 19:05 | emiller | Relationship added | related to 0006350 |
| 2025-09-29 19:19 | emiller | Note Added: 0003461 | |
| 2025-09-30 12:13 | emiller | Note Edited: 0003461 | View Revisions |
| 2025-09-30 12:14 | emiller | Note Added: 0003462 | |
| 2025-09-30 12:15 | emiller | Status | assigned => resolved |
| 2025-09-30 12:15 | emiller | Resolution | open => fixed |
| 2025-09-30 12:15 | emiller | Fixed in Version | => 3.16.7 |
| 2025-09-30 12:15 | emiller | Target Version | 3.16.8 => 3.16.7 |
| 2025-10-03 22:47 | pbelov | Note Added: 0003481 | |
| 2025-10-03 22:47 | pbelov | Status | resolved => closed |