View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003014 | SymmetricDS | Improvement | public | 2017-03-14 12:49 | 2017-03-14 17:47 |
| Reporter | mmichalek | Assigned To | mmichalek | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.0 | ||||
| Target Version | 3.8.18 | Fixed in Version | 3.8.18 | ||
| Summary | 0003014: During Extract, ORA-01438: value larger than specified precision allowed for this column | ||||
| Description | There is a cast that occurs during the extract query to NUMBER(30,10). If there are numbers with more precision than this the following gets logged: ORA-01438: value larger than specified precision allowed for this column The precision of 30,10 is driven by the parameter "oracle.template.precision". The fix in this issue is to change the default value of oracle.template.precision to *,38. Which should have semantics of 38,38 per: https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT1832 | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-03-14 12:49 | mmichalek | New Issue | |
| 2017-03-14 12:49 | mmichalek | Status | new => assigned |
| 2017-03-14 12:49 | mmichalek | Assigned To | => mmichalek |
| 2017-03-14 12:53 | mmichalek | Status | assigned => resolved |
| 2017-03-14 12:53 | mmichalek | Resolution | open => fixed |
| 2017-03-14 12:53 | mmichalek | Fixed in Version | => 3.8.18 |
| 2017-03-14 13:00 | mmichalek | Changeset attached | => SymmetricDS 3.8 a5b32d18 |
| 2017-03-14 17:47 | chenson | Status | resolved => closed |