0004159: INTERBASE Length of ROW_DATA and OLD_DATA are now only varchar(3840) !! - SymmetricDS

ID	Project	Category	View Status	Date Submitted	Last Update

0004159	SymmetricDS Pro	Installation	public	2019-11-22 12:16	2021-06-19 21:04

Reporter	gilles.riand	Assigned To	pmarzullo
Priority	high
Status	closed	Resolution	fixed
Product Version	3.11.0
Target Version	3.11.1	Fixed in Version	3.11.1

Summary	0004159: INTERBASE Length of ROW_DATA and OLD_DATA are now only varchar(3840) !!
Description	The 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) !
Tags	ddl/schema, dialect: interbase

gilles.riand 2019-11-22 12:16 reporter	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 (45,820 bytes) 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 (45,820 bytes)

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.

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

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