View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006026 | SymmetricDS Pro | Bug | public | 2023-10-17 16:23 | 2023-12-01 20:57 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.9 | ||||
| Target Version | 3.14.10 | Fixed in Version | 3.14.10 | ||
| Summary | 0006026: SQL Server Bulk issue when batch column count is different than target table column count | ||||
| Description | The calculation of whether the columns from the batch file need to be reordered when running in BCP batch mode does not take into account when the number of columns in the table is less than the number of columns in the batch file. The code checks to see if the number of columns in the batch and the target table are different. If so, then mark the flag that the columns need reordered. But then it goes on and checks the names of each column from the batch and compares to the names of the columns in the table. If the number of columns in the target table is less than the number of columns in the batch, then an ArrayIndexOutOfBoundsException is thrown because the number of elements in the array for the target table columns is too short and does not exist. | ||||
| Steps To Reproduce | BCP load a table at the target when the number of columns in the target table is less than the number of columns in the source table. | ||||
| Additional Information | If the number of columns is different between the batch and the target table, set the flag indicating that the columns need reordered and skip the column name comparison, which is not needed when the number of columns is different. | ||||
| Tags | bulk, dialect: sql-server | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-10-17 16:23 | pmarzullo | New Issue | |
| 2023-10-17 16:23 | pmarzullo | Status | new => assigned |
| 2023-10-17 16:23 | pmarzullo | Assigned To | => pmarzullo |
| 2023-10-17 16:23 | pmarzullo | Tag Attached: bulk | |
| 2023-10-17 16:23 | pmarzullo | Tag Attached: dialect: sql-server | |
| 2023-10-17 16:59 | pmarzullo | Status | assigned => resolved |
| 2023-10-17 16:59 | pmarzullo | Resolution | open => fixed |
| 2023-10-17 16:59 | pmarzullo | Fixed in Version | => 3.15.1 |
| 2023-10-17 16:59 | pmarzullo | Fixed in Version | 3.15.1 => 3.14.10 |
| 2023-10-27 20:06 | admin | Status | resolved => closed |
| 2023-12-01 20:57 | elong | Relationship added | related to 0006027 |