View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004202 | SymmetricDS | Bug | public | 2019-12-12 17:14 | 2020-01-02 14:42 |
| Reporter | nrichardson | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.3 | ||||
| Target Version | 3.11.3 | Fixed in Version | 3.11.3 | ||
| Summary | 0004202: Oracle Decimal precision can contain 40 digits after the decimal but sync only sends 39 | ||||
| Description | On an Oracle table containing a NUMBER field with no precision defined, Oracle allows the precision of up to 39 or 40 digits after the decimal even though the field can only be specifically created as NUMBER(38,0) max. The default parameter oracle.template.precision is *,38 which will truncate / round values with 39 or 40 digits of precision to 38 digits. Changing this parameter to *,40 still only sends 39 digits to the target even though the triggers all reflect cast(... number(*,40)). | ||||
| Steps To Reproduce | Update parameter to *,40 Create an Oracle table with a NUMBER field, insert a row with a value of 0.1666666666666666666666666666666666666667 Compare the target value, should see one less digit 0.166666666666666666666666666666666666667 | ||||
| Additional Information | Tried to update the parameter to *,41 and still reduces to 39 digits | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.11 d1203778 2019-12-18 09:51:36 Details Diff |
0004202: Handle 39 and 40 digit numbers on Oracle |
Affected Issues 0004202 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleTriggerTemplate.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java | Diff File | ||
| mod - symmetric-core/src/main/resources/symmetric-default.properties | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-12-12 17:14 | nrichardson | New Issue | |
| 2019-12-12 17:15 | nrichardson | Category | Improvement => Bug |
| 2019-12-18 14:51 | elong | Assigned To | => elong |
| 2019-12-18 14:51 | elong | Status | new => assigned |
| 2019-12-18 14:52 | elong | Status | assigned => resolved |
| 2019-12-18 14:52 | elong | Resolution | open => fixed |
| 2019-12-18 14:52 | elong | Fixed in Version | => 3.11.3 |
| 2019-12-18 14:52 | elong | Target Version | => 3.11.3 |
| 2019-12-18 15:00 | admin | Changeset attached | => SymmetricDS 3.11 d1203778 |
| 2020-01-02 14:42 | admin | Status | resolved => closed |