View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006350 | SymmetricDS | Bug | public | 2024-04-16 16:35 | 2025-09-29 19:05 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.4 | ||||
| Target Version | 3.15.5 | Fixed in Version | 3.15.5 | ||
| Summary | 0006350: H2 version 2 LONGVARCHAR implementation uses VARCHAR(1000000000) | ||||
| Description | H2 version 2 implements a LONGVARCHAR as a VARCHAR(1000000000). It comes back as a VARCHAR with a size of 1000000000, and causes a DDL change in the comparator to change it to a LONGVARCHAR. Intercept the VARCHAR(1000000000) and change it to a LONGVARCHAR when reading DDL. I couldn't reproduce this issue in SymmetricDS, but METL using SymmetricDS to handle the schema ran into this problem. | ||||
| Tags | ddl/schema, dialect: h2 | ||||
| related to | 0006514 | closed | pmarzullo | H2 always reconfiguring sym_node table when schema XML changes most_recent_active_table column from varchar to varchar(255) |
| related to | 0007083 | closed | emiller | When sending a table schema containing a LONGVARBINARY column to an H2 2.x node, the table always gets rebuilt |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-04-16 16:35 | pmarzullo | New Issue | |
| 2024-04-16 16:35 | pmarzullo | Status | new => assigned |
| 2024-04-16 16:35 | pmarzullo | Assigned To | => pmarzullo |
| 2024-04-16 16:35 | pmarzullo | Tag Attached: ddl/schema | |
| 2024-04-16 16:35 | pmarzullo | Tag Attached: dialect: h2 | |
| 2024-04-16 16:38 | pmarzullo | Status | assigned => resolved |
| 2024-04-16 16:38 | pmarzullo | Resolution | open => fixed |
| 2024-04-16 16:38 | pmarzullo | Fixed in Version | => 3.15.5 |
| 2024-04-19 15:46 | pmarzullo | Changeset attached | => SymmetricDS 3.15 b5cf4d44 |
| 2024-04-23 16:58 | admin | Status | resolved => closed |
| 2024-06-24 20:40 | pmarzullo | Relationship added | related to 0006514 |
| 2025-09-29 19:05 | emiller | Relationship added | related to 0007083 |