View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004373 | SymmetricDS | Improvement | public | 2020-04-27 18:38 | 2024-08-21 17:39 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.8 | ||||
| Target Version | 3.11.13 | Fixed in Version | 3.11.13 | ||
| Summary | 0004373: SQL Server supports filtered indexes, need to add support of filtered indexes in ddlutils | ||||
| Description | CREATE INDEX FIBillOfMaterialsWithEndDate ON Production.BillOfMaterials (ComponentID, StartDate) WHERE EndDate IS NOT NULL ; Notice the WHERE clause in the creation of the index. Need to change database.dtd, adding a new attribute to index and unique sections. New attribute could be "filter". Need to add support to DDL Reader to read filter specification for SQL Server Reader, all others should default to not supporting it. Export to XML should add this attribute to indexes when specified. DDL Writer needs to support this new attribute. | ||||
| Tags | ddl/schema, dialect: sql-server | ||||
|
SymmetricDS: 3.11 69fa8a77 2020-09-24 10:01:31 Details Diff |
0004373: SQL Server supports filtered indexes, need to add support of filtered indexes in ddlutils |
Affected Issues 0004373 |
|
| 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 | ||
| add - symmetric-db/src/main/java/org/jumpmind/db/model/PlatformIndex.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/AbstractDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mssql/MsSql2008DdlBuilder.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSqlDdlReader.java | Diff File | ||
|
SymmetricDS: 3.12 94f6415a 2020-09-24 10:01:31 Details Diff |
0004373: SQL Server supports filtered indexes, need to add support of filtered indexes in ddlutils |
Affected Issues 0004373 |
|
| 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 | ||
| add - symmetric-db/src/main/java/org/jumpmind/db/model/PlatformIndex.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/AbstractDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mssql/MsSql2008DdlBuilder.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSqlDdlReader.java | Diff File | ||
|
SymmetricDS: 3.11 b62e5a69 2020-09-24 10:21:01 Details Diff |
0004373: SQL Server supports filtered indexes, need to add support of filtered indexes in ddlutils |
Affected Issues 0004373 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/io/DatabaseXmlUtil.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-04-27 18:38 | pmarzullo | New Issue | |
| 2020-04-27 18:38 | pmarzullo | Tag Attached: ddl/schema | |
| 2020-04-27 18:38 | pmarzullo | Tag Attached: dialect: sql-server | |
| 2020-07-06 13:00 | pmarzullo | Assigned To | => pmarzullo |
| 2020-07-06 13:00 | pmarzullo | Status | new => assigned |
| 2020-09-24 14:04 | pmarzullo | Relationship added | related to 0004568 |
| 2020-09-24 14:06 | pmarzullo | Target Version | => 3.11.13 |
| 2020-09-24 14:06 | pmarzullo | Status | assigned => resolved |
| 2020-09-24 14:06 | pmarzullo | Resolution | open => fixed |
| 2020-09-24 14:06 | pmarzullo | Fixed in Version | => 3.11.13 |
| 2020-09-24 15:00 | pmarzullo | Changeset attached | => SymmetricDS 3.11 b62e5a69 |
| 2020-09-24 15:00 | pmarzullo | Changeset attached | => SymmetricDS 3.11 69fa8a77 |
| 2020-09-24 15:00 | pmarzullo | Changeset attached | => SymmetricDS 3.12 94f6415a |
| 2020-10-05 16:49 | pmarzullo | Status | resolved => assigned |
| 2020-10-05 16:49 | pmarzullo | Note Added: 0001804 | |
| 2020-10-05 16:50 | pmarzullo | Resolution | fixed => open |
| 2020-10-05 16:50 | pmarzullo | Fixed in Version | 3.11.13 => |
| 2020-10-06 17:44 | pmarzullo | Status | assigned => resolved |
| 2020-10-06 17:44 | pmarzullo | Resolution | open => fixed |
| 2020-10-06 17:44 | pmarzullo | Fixed in Version | => 3.11.13 |
| 2020-11-09 15:15 | admin | Status | resolved => closed |
| 2024-08-21 17:39 | cquamme | Relationship added | related to 0002325 |