0004282: Data load wizard truncate sym_node error - SymmetricDS

ID	Project	Category	View Status	Date Submitted	Last Update

0004282	SymmetricDS Pro	Bug	public	2020-02-11 17:37	2020-02-14 17:45

Reporter	elong	Assigned To	elong
Priority	normal
Status	closed	Resolution	fixed
Product Version	3.10.4
Target Version	3.10.10	Fixed in Version	3.10.10

Summary	0004282: Data load wizard truncate sym_node error
Description	The data load wizard sends a custom "truncate table x" statement as a SQL event, but the the table_name and trigger_hist are for sym_node. The database writer changes the SQL to use the target table indicated (sym_node) so it can properly use catalog/schema and quoting, but the table name is now wrong.
Tags	No tags attached.

SymmetricDS: 3.11 36b59e15 2020-02-12 09:15:07 admin Details Diff	0004282: Data load wizard truncate sym_node error	Affected Issues 0004282
	mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java	Diff File
SymmetricDS: 3.10 3a723ee6 2020-02-12 09:15:46 admin Details Diff	0004282: Data load wizard truncate sym_node error	Affected Issues 0004282
	mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java	Diff File

Date Modified	Username	Field	Change
2020-02-11 17:37	elong	New Issue
2020-02-11 17:46	elong	Note Added: 0001682
2020-02-12 14:16	elong	Assigned To	=> elong
2020-02-12 14:16	elong	Status	new => resolved
2020-02-12 14:16	elong	Resolution	open => fixed
2020-02-12 14:16	elong	Fixed in Version	=> 3.10.10
2020-02-12 15:00	admin	Changeset attached	=> SymmetricDS 3.10 3a723ee6
2020-02-12 15:00	admin	Changeset attached	=> SymmetricDS 3.11 36b59e15
2020-02-14 17:45	elong	Status	resolved => closed

elong 2020-02-11 17:46 developer ~0001682	This appears to be a compatibility bug. In 3.8, the table_name/trigger_hist used on the SQL event is SYM_NODE, while in 3.10 it uses the user's table.