View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006508 | SymmetricDS | Bug | public | 2024-06-20 19:46 | 2024-06-20 20:00 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.8 | Fixed in Version | 3.15.8 | ||
| Summary | 0006508: SQL-Server DDL table alterations when change not needed | ||||
| Description | On SQL-Server, there are some cases where a create table event will alter the table when no alteration was needed. 1. The primary key looks like it needs set to "not null", but a primary key by SQL standard definition cannot be null already. The XML does not specify the "required" attribute, but it is implied by the "primaryKey" attribute. <column name="id" primaryKey="true" primaryKeySeq="1" type="INTEGER" size="10" default="0"> </column> 2. A data type of NUMERIC with a size and precision left unspecified looks different because the precision is left as -1. For example, NUMERIC(15,0) is compared to NUMERIC(15,-1). <column name="vendno" type="NUMERIC" size="15" default="0"> </column> 3. A default of "sysdate" that works on Oracle or OpenEdge for a DATE data type causes a failure. <column name="enterdt" type="DATE" size="4" default="sysdate"> </column> | ||||
| Tags | ddl/schema, dialect: sql-server | ||||
|
SymmetricDS: 3.15 ba26b721 2024-06-20 19:48:01 Details Diff |
0006508: use INFO log since DDL is already logged |
Affected Issues 0006508 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/alter/ModelComparator.java | Diff File | ||
|
SymmetricDS: 3.15 5b49ea13 2024-06-20 19:48:20 Details Diff |
0006508: primary key implies required is true |
Affected Issues 0006508 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/model/Column.java | Diff File | ||
|
SymmetricDS: 3.15 6b179c35 2024-06-20 19:48:46 Details Diff |
0006508: default of sysdate on date |
Affected Issues 0006508 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mssql/MsSql2008DdlBuilder.java | Diff File | ||
|
SymmetricDS: 3.15 80635577 2024-06-20 19:49:21 Details Diff |
0006508: comparison if precision is unspecified |
Affected Issues 0006508 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDdlBuilder.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-06-20 19:46 | elong | New Issue | |
| 2024-06-20 19:46 | elong | Status | new => assigned |
| 2024-06-20 19:46 | elong | Assigned To | => elong |
| 2024-06-20 19:46 | elong | Tag Attached: ddl/schema | |
| 2024-06-20 19:46 | elong | Tag Attached: dialect: sql-server | |
| 2024-06-20 19:49 | elong | Status | assigned => resolved |
| 2024-06-20 19:49 | elong | Resolution | open => fixed |
| 2024-06-20 19:49 | elong | Fixed in Version | => 3.15.8 |
| 2024-06-20 20:00 | admin | Changeset attached | => SymmetricDS 3.15 80635577 |
| 2024-06-20 20:00 | admin | Changeset attached | => SymmetricDS 3.15 6b179c35 |
| 2024-06-20 20:00 | admin | Changeset attached | => SymmetricDS 3.15 5b49ea13 |
| 2024-06-20 20:00 | admin | Changeset attached | => SymmetricDS 3.15 ba26b721 |
| 2024-08-16 17:45 | admin | Status | resolved => closed |