/
release-notes-2.4.x.html
149 lines (139 loc) · 9.21 KB
/
release-notes-2.4.x.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
<html>
<body>
<h1>
Version 2.4.1
</h1>
<h2> Bug
</h2>
<ul>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-505'>SYMMETRICDS-505</a>] - Support NCLOB column on oracle
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-506'>SYMMETRICDS-506</a>] - Support DDL create of NChar/NVarchar/Nclob
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-508'>SYMMETRICDS-508</a>] - SqlScript does not execute a result set if a select is passed to the script.
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-509'>SYMMETRICDS-509</a>] - Schema upgrade fails on Firebird/Interbase
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-512'>SYMMETRICDS-512</a>] - ojdbc6.jar and ojdbc5.jar from Oracle 11g distribution causes some SymmetricDS tables to be dropped and recreated.
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-513'>SYMMETRICDS-513</a>] - Cached table metadata could get out of sync when in cluster (sync triggers might run on only one node)
</li>
</ul>
<h2> Improvement
</h2>
<ul>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-507'>SYMMETRICDS-507</a>] - Get rid of the columns out of order detection in ddlutils. It just causes tables to be rebuilt during upgrades when they really don't need to be.
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-510'>SYMMETRICDS-510</a>] - Document how to re-send data by creating reload events
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-511'>SYMMETRICDS-511</a>] - Add new service url that returns information about a node in the properties format: http://hostname/sync/info
</li>
</ul>
<h1>
Version 2.4.0
</h1>
<h2> Bug
</h2>
<ul>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-428'>SYMMETRICDS-428</a>] - Update trigger getting ORA-01489 error
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-446'>SYMMETRICDS-446</a>] - sym_largeobject function in Postgresql returns only a part of the binary object
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-447'>SYMMETRICDS-447</a>] - Tinyint loses sign
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-454'>SYMMETRICDS-454</a>] - PostgreSQL BLOB handling fails.
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-455'>SYMMETRICDS-455</a>] - Derby CLOB fails if string contains quotes.
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-458'>SYMMETRICDS-458</a>] - Table prefix not being replaced for initial load sql for a postgres blob column
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-459'>SYMMETRICDS-459</a>] - Primary key index being created with unexpected name causes error
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-460'>SYMMETRICDS-460</a>] - Initial load gets arithmetic exception, numeric overflow, or string truncation
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-466'>SYMMETRICDS-466</a>] - Tomcat shutdown hangs when SymmetricDS is deployed as a war
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-467'>SYMMETRICDS-467</a>] - "Skipped" is spelled wrong in the IncomingBatch.Status enumeration
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-468'>SYMMETRICDS-468</a>] - Allow table names with mixed and upper case
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-469'>SYMMETRICDS-469</a>] - Data can be skipped when the beginning or end of a batch is filled in.
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-471'>SYMMETRICDS-471</a>] - Sync of null BLOB causes null pointer exception
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-472'>SYMMETRICDS-472</a>] - Case sensitive table names
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-474'>SYMMETRICDS-474</a>] - Table metadata written out during an initial load that does not respect sym_router.target_table_name
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-478'>SYMMETRICDS-478</a>] - Initial load data should be filterable via the IExtractFilter
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-486'>SYMMETRICDS-486</a>] - Multiple triggers get created on sym_ tables after an upgrade
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-490'>SYMMETRICDS-490</a>] - Exception throws on update clob field
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-492'>SYMMETRICDS-492</a>] - Query that retrieves data to route can slow down on big joins between sym_data and sym_data_gap
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-496'>SYMMETRICDS-496</a>] - Outgoing batch can be marked as OK if Incoming batch fails to update to OK
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-498'>SYMMETRICDS-498</a>] - Outgoing batch stats can be overwritten if an error occurs after the stats have been reset for an extract retry
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-499'>SYMMETRICDS-499</a>] - Only the last temporary file in a sync is being kept around for reuse in case of a network error
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-501'>SYMMETRICDS-501</a>] - Prefix SymmetricDS indexes so SymmetricDS tables can coexist in the same database
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-504'>SYMMETRICDS-504</a>] - Datetime value of '0000-00-00 00:00:00' does not sync properly on MySQL
</li>
</ul>
<h2> Improvement
</h2>
<ul>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-372'>SYMMETRICDS-372</a>] - Don't allow synchronization and log message in the push and pull servlets if the node is sync_enabled=0
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-433'>SYMMETRICDS-433</a>] - Document the external_select feature better
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-453'>SYMMETRICDS-453</a>] - Allow JDBC connection properties to be set via a symmetric property
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-456'>SYMMETRICDS-456</a>] - Move SpringWireableSymmetricEngine to symmetric-core
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-470'>SYMMETRICDS-470</a>] - Support interval data type
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-475'>SYMMETRICDS-475</a>] - Upgrade packaged HSQLDB to 2.2.4
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-476'>SYMMETRICDS-476</a>] - Improve explanation of keystore and cert generation
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-477'>SYMMETRICDS-477</a>] - Upgrade the packaged MySQL JDBC Driver to the latest version (5.1.17)
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-480'>SYMMETRICDS-480</a>] - Improve configuration troubleshooting by not allowing triggers to exist with a channel_id that does not exist.
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-482'>SYMMETRICDS-482</a>] - Update the column match router to accept router_expressions that are concatenated by OR instead of a new line
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-484'>SYMMETRICDS-484</a>] - Document use of OLD_ in column match expressions
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-487'>SYMMETRICDS-487</a>] - User's Guide - Router section - missing summary bullets and uses two terms
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-488'>SYMMETRICDS-488</a>] - User's Guide - verify that the initial load select somewhere identifies the alias of the table being loaded
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-495'>SYMMETRICDS-495</a>] - Do not extract the same batch for the same node at the same time if a network error occurs
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-497'>SYMMETRICDS-497</a>] - Default dataloader.max.rows.before.commit to 10000 so tables with millions of rows don't try to commit the entire table all at once
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-500'>SYMMETRICDS-500</a>] - Set max_batch_to_send to 1 as the default setting for the reload channel.
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-503'>SYMMETRICDS-503</a>] - Print out query string and remote host and ip address of requests that are not mapped to an existing server
</li>
</ul>
<h2> New Feature
</h2>
<ul>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-4'>SYMMETRICDS-4</a>] - Stream LOB (large object), BLOB, and CLOB columns
</li>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-448'>SYMMETRICDS-448</a>] - Allow table names using keywords
</li>
</ul>
<h2> Task
</h2>
<ul>
<li>[<a href='http://jira.codehaus.org/browse/SYMMETRICDS-387'>SYMMETRICDS-387</a>] - Discuss sym_channel settings and how they effect synchronization in the users guide
</li>
</ul>
</html>