View Issue Details

IDProjectCategoryView StatusLast Update
0006514SymmetricDSBugpublic2024-06-24 21:00
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.7 
Target Version3.15.8Fixed in Version3.15.8 
Summary0006514: H2 always reconfiguring sym_node table when schema XML changes most_recent_active_table column from varchar to varchar(255)
DescriptionH2 always reconfigures the sym_node table on startup because of schema change for column most_recent_active_table from varchar to varchar(255).
It always attempts to change column from longvarchar to longvarchar.
Steps To Reproduce1. Startup SymmetricDS version 3.15.0 and define a connection to H2.
2. Upgrade to version 3.15.7 and start up SymmetricDS and watch table modifications to sym_node.
3. Restart instance and watch table modifications to sym_node.
TagsNo tags attached.

Relationships

related to 0006350 closedpmarzullo H2 version 2 LONGVARCHAR implementation uses VARCHAR(1000000000) 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 f9703896

2024-06-24 20:55:40

pmarzullo

Details Diff
0006514: H2 always reconfiguring sym_node table when schema XML changes
most_recent_active_table column from varchar to varchar(255)
Affected Issues
0006514
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/h2/H2SymmetricDialect.java Diff File

Issue History

Date Modified Username Field Change
2024-06-24 20:40 pmarzullo New Issue
2024-06-24 20:40 pmarzullo Status new => assigned
2024-06-24 20:40 pmarzullo Assigned To => pmarzullo
2024-06-24 20:40 pmarzullo Relationship added related to 0006350
2024-06-24 20:46 pmarzullo Steps to Reproduce Updated View Revisions
2024-06-24 20:56 pmarzullo Status assigned => resolved
2024-06-24 20:56 pmarzullo Resolution open => fixed
2024-06-24 20:56 pmarzullo Fixed in Version => 3.15.8
2024-06-24 21:00 pmarzullo Changeset attached => SymmetricDS 3.15 f9703896
2024-08-16 17:45 admin Status resolved => closed