View Issue Details

IDProjectCategoryView StatusLast Update
0004159SymmetricDS ProInstallationpublic2021-06-19 21:04
Reportergilles.riand Assigned Topmarzullo  
Priorityhigh 
Status closedResolutionfixed 
Product Version3.11.0 
Target Version3.11.1Fixed in Version3.11.1 
Summary0004159: INTERBASE Length of ROW_DATA and OLD_DATA are now only varchar(3840) !!
DescriptionThe Install Script For Interbase is wrong.

We need the maximum length for the Fields ROW_DATA and OLD_DATA in SYM_DATA TABLE So with interbase it's 4096
But with your correction on issue 0003362 all the big VARCHAR fields are now only 3840.

Be Carefull only "ROW_DATA" AND "OLD_DATA" need varchar(4096) !

Tagsddl/schema, dialect: interbase

Activities

gilles.riand

2019-11-22 12:16

reporter  

pmarzullo

2019-11-22 15:44

developer   ~0001647

LONGVARCHAR columns are mapped back to VARCHAR(4096), and sym_trigger DESCRIPTION column changed to VARCHAR(1024) for Interbase. This makes the SYM_TRIGGER table width less than 65536.

Related Changesets

SymmetricDS: 3.11 4030b2e4

2019-11-22 10:42:40

Philip Marzullo

Details Diff
0004159: INTERBASE Length of ROW_DATA and OLD_DATA are now only
varchar(3840) !!
Affected Issues
0004159
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/interbase/InterbaseSymmetricDialect.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/interbase/InterbaseDdlBuilder.java Diff File

Issue History

Date Modified Username Field Change
2019-11-22 12:16 gilles.riand New Issue
2019-11-22 12:16 gilles.riand File Added: 2019-11-22 13_03_53-Table _ [SYM_DATA] _ SYMDS-3-11-0_TEST (127.0.0.1_3050_G__SYMDS_3_11_0_TEST.IB).png
2019-11-22 15:11 pmarzullo Assigned To => pmarzullo
2019-11-22 15:11 pmarzullo Status new => assigned
2019-11-22 15:12 pmarzullo Target Version => 3.11.1
2019-11-22 15:12 pmarzullo Description Updated View Revisions
2019-11-22 15:40 pmarzullo Tag Attached: dialect: interbase
2019-11-22 15:40 pmarzullo Tag Attached: ddl/schema
2019-11-22 15:44 pmarzullo Status assigned => resolved
2019-11-22 15:44 pmarzullo Resolution open => fixed
2019-11-22 15:44 pmarzullo Fixed in Version => 3.11.1
2019-11-22 15:44 pmarzullo Note Added: 0001647
2019-11-22 16:00 Changeset attached => SymmetricDS 3.11 4030b2e4
2019-12-02 20:10 admin Status resolved => closed