View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006677 | SymmetricDS | Improvement | public | 2024-12-13 19:02 | 2025-02-14 14:27 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.13 | Fixed in Version | 3.15.13 | ||
| Summary | 0006677: Support include column for SQL Server indexes (covering index) | ||||
| Description | SQL Server supports covering indexes, which allows the creation of a non-clustered index where the columns that are used for the index are set up in a b-tree data structure, and other columns can be included in the index without being a part of the b-tree index so that a query can be satisfied by only the index instead of going to the index and the table space. DDL Utils will need to be updated to support the INCLUDE (column list) part of the index definition. | ||||
| Tags | ddl/schema, dialect: sql-server | ||||
|
|
create table t2( id integer not null, i2 integer not null, i3 integer not null, d1 varchar(255) not null, d2 varchar(255) not null, d3 varchar(255) not null, constraint t2_pk primary key(id) ); create index ix_t2_1 on t2(id, i2) include(i3, d1, d2, d3); |
|
|
There is no support for changed indexes. So I am going to add support for changed indexes on this issue as well. |
|
|
Feature branch based off of 3.15 branch: feature/6677_support_include_columns_sql_server_indexes |
|
|
Released as part of 3.15.13 |
|
SymmetricDS: 3.15 f5173dbc 2025-01-23 15:12:54 philipmarzullo64 Committer: GitHub Details Diff |
6677: push feature branch (0000219) Co-authored-by: Philip Marzullo <pmarzullo@jumpmind.com> |
Affected Issues 0006677 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/alter/ModelComparator.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/io/DatabaseXmlUtil.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/model/IIndex.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/model/IndexImpBase.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/model/NonUniqueIndex.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/model/UniqueIndex.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mssql/MsSql2005DdlBuilder.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSqlDdlReader.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-12-13 19:02 | pmarzullo | New Issue | |
| 2024-12-13 19:02 | pmarzullo | Status | new => assigned |
| 2024-12-13 19:02 | pmarzullo | Assigned To | => pmarzullo |
| 2024-12-13 19:02 | pmarzullo | Tag Attached: ddl/schema | |
| 2024-12-13 19:02 | pmarzullo | Tag Attached: dialect: sql-server | |
| 2024-12-13 19:06 | pmarzullo | Relationship added | related to 0006678 |
| 2025-01-03 14:07 | pbelov | Target Version | 3.15.12 => 3.15.13 |
| 2025-01-14 14:20 | pmarzullo | Note Added: 0002591 | |
| 2025-01-15 20:33 | pmarzullo | Note Added: 0002592 | |
| 2025-01-15 20:51 | pmarzullo | Note Added: 0002593 | |
| 2025-01-15 20:52 | pmarzullo | Note Edited: 0002593 | View Revisions |
| 2025-01-23 16:00 | Changeset attached | => SymmetricDS 3.15 f5173dbc | |
| 2025-01-27 18:54 | pmarzullo | Status | assigned => resolved |
| 2025-01-27 18:54 | pmarzullo | Resolution | open => fixed |
| 2025-01-27 18:54 | pmarzullo | Fixed in Version | => 3.15.13 |
| 2025-02-14 14:27 | pbelov | Note Added: 0002639 | |
| 2025-02-14 14:27 | pbelov | Status | resolved => closed |