View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004580 | SymmetricDS | Bug | public | 2020-10-07 16:40 | 2020-11-09 15:14 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.10.0 | ||||
| Target Version | 3.10.13 | Fixed in Version | 3.10.13 | ||
| Summary | 0004580: SQL Server bulk loader data conversion with decimal scientific notation | ||||
| Description | For SQL-Server dialect, sending an initial load for a table with decimal, float, or real data types can result in an error for the bulk loader. The decimal data is sent in scientific notation, which is not expected by the bulk insert command. Our standard batch CSV protocol should probably be in decimal format (0.00000001), not scientific notation (1E-8) for compatibility. INFO [client] [ManageIncomingBatchListener] [client-dataloader-97] Bulk loading failed for this batch 12970348, falling back to default loading. (org.jumpmind.db.sql.SqlException: Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 74, column 20 (percentage).) | ||||
| Tags | bulk, dialect: sql-server | ||||
|
SymmetricDS: 3.10 f5d89715 2020-10-19 14:47:11 Details Diff |
0004580: SQL Server bulk loader data conversion with decimal scientific notation |
Affected Issues 0004580 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java | Diff File | ||
|
SymmetricDS: 3.11 e85e5ab7 2020-10-19 14:47:11 Details Diff |
0004580: SQL Server bulk loader data conversion with decimal scientific notation |
Affected Issues 0004580 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java | Diff File | ||
|
SymmetricDS: 3.12 0ddf4561 2020-10-19 14:47:11 Details Diff |
0004580: SQL Server bulk loader data conversion with decimal scientific notation |
Affected Issues 0004580 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-10-07 16:40 | elong | New Issue | |
| 2020-10-07 16:40 | elong | Status | new => assigned |
| 2020-10-07 16:40 | elong | Assigned To | => elong |
| 2020-10-07 16:40 | elong | Tag Attached: bulk | |
| 2020-10-07 16:40 | elong | Tag Attached: dialect: sql-server | |
| 2020-10-19 15:00 | admin | Changeset attached | => SymmetricDS 3.10 f5d89715 |
| 2020-10-19 15:00 | admin | Changeset attached | => SymmetricDS 3.11 e85e5ab7 |
| 2020-10-19 15:00 | admin | Changeset attached | => SymmetricDS 3.12 0ddf4561 |
| 2020-10-19 15:00 | elong | Status | assigned => resolved |
| 2020-10-19 15:00 | elong | Resolution | open => fixed |
| 2020-10-19 15:00 | elong | Fixed in Version | => 3.10.13 |
| 2020-10-19 15:00 | elong | Issue cloned: 0004597 | |
| 2020-10-19 15:00 | elong | Relationship added | related to 0004597 |
| 2020-11-09 15:14 | admin | Status | resolved => closed |