View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002940 | SymmetricDS | Improvement | public | 2016-12-09 19:30 | 2016-12-30 13:10 |
| Reporter | chenson | Assigned To | chenson | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.11 | ||||
| Target Version | 3.8.12 | Fixed in Version | 3.8.12 | ||
| Summary | 0002940: Sql Server - An implicit conversion on column [sym_outgoing_batch].[status] to data type "nchar" may be causing index su | ||||
| Description | An implicit conversion on column [dbo].[sym_outgoing_batch].[status] to data type "nchar" may be causing index suppression An implicit conversion in a WHERE clause of a query in [IVR_GUARDIAN] can cause index suppression if an indexed column is of a different type resulting in a scan rather than a seek. Recommendation: It is recommended that you consider redesigning this WHERE clause to prevent index suppression and performance degradation. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.8 d9ec0bf9 2016-12-09 14:44:08 Details Diff |
0002940: Sql Server - An implicit conversion on column [sym_outgoing_batch].[status] to data type "nchar" may be causing index su |
Affected Issues 0002940 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/OutgoingBatchService.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-12-09 19:30 | chenson | New Issue | |
| 2016-12-09 19:30 | chenson | Status | new => assigned |
| 2016-12-09 19:30 | chenson | Assigned To | => chenson |
| 2016-12-09 20:00 | chenson | Changeset attached | => SymmetricDS 3.8 d9ec0bf9 |
| 2016-12-15 00:30 | chenson | Status | assigned => resolved |
| 2016-12-15 00:30 | chenson | Fixed in Version | => 3.8.12 |
| 2016-12-15 00:30 | chenson | Resolution | open => fixed |
| 2016-12-30 13:10 | chenson | Status | resolved => closed |