View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004902 | SymmetricDS | Bug | public | 2021-03-17 18:05 | 2021-03-30 19:46 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.8 | Fixed in Version | 3.12.8 | ||
| Summary | 0004902: Auto resolve when primary key has binary/varbinary | ||||
| Description | The auto resolver is using dynamic SQL statements to remove blocking rows, which works when the primary key or unique key is string or numeric data types. A data type of varbinary or binary does not work because it is not encoded properly as a binary literal. Long term, for next major/minor release, the auto resolver should be converted to use prepared SQL statements and object values, so it works with any data types. Short term, for this issue, we can fix the dynamic statements to use a binary literal, which should work on platforms like SQL-Server, MySQL, and Postgres. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.12 1e832ed0 2021-03-17 19:06:19 Details Diff |
0004902: Auto resolve when primary key has binary/varbinary |
Affected Issues 0004902 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/firebird/FirebirdDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mssql/MsSql2000DdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mysql/MySqlDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/oracle/OracleDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/DmlStatement.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/Row.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java | Diff File | ||
|
SymmetricDS: 3.12 c8daaf15 2021-03-18 21:00:14 Details Diff |
0004902: Auto resolve when primary key has binary/varbinary |
Affected Issues 0004902 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/DmlStatement.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-03-17 18:05 | elong | New Issue | |
| 2021-03-17 18:05 | elong | Status | new => assigned |
| 2021-03-17 18:05 | elong | Assigned To | => elong |
| 2021-03-17 19:06 | elong | Status | assigned => resolved |
| 2021-03-17 19:06 | elong | Resolution | open => fixed |
| 2021-03-17 19:06 | elong | Fixed in Version | => 3.12.8 |
| 2021-03-17 20:00 | admin | Changeset attached | => SymmetricDS 3.12 1e832ed0 |
| 2021-03-18 22:00 | admin | Changeset attached | => SymmetricDS 3.12 c8daaf15 |
| 2021-03-30 19:46 | admin | Status | resolved => closed |