View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0006350SymmetricDSBugpublic2024-04-16 16:352024-06-24 20:40
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.4 
Target Version3.15.5Fixed in Version3.15.5 
Summary0006350: H2 version 2 LONGVARCHAR implementation uses VARCHAR(1000000000)
DescriptionH2 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.
Tagsddl/schema, dialect: h2

Relationships

related to 0006514 closedpmarzullo H2 always reconfiguring sym_node table when schema XML changes most_recent_active_table column from varchar to varchar(255) 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 b5cf4d44

2024-04-16 16:38:24

pmarzullo

Details Diff 		0006350: H2 version 2 LONGVARCHAR implementation uses
VARCHAR(1000000000)		 Affected Issues
0006350
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/h2/H2DdlReader.java Diff File

Issue History

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