View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update | 
|---|---|---|---|---|---|
| 0005368 | SymmetricDS | Bug | public | 2022-07-20 15:20 | 2022-08-30 13:03 | 
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.5.0 | ||||
| Target Version | 3.13.7 | Fixed in Version | 3.13.7 | ||
| Summary | 0005368: DDL detects change in column data type for DATE on Oracle | ||||
| Description | For Oracle, when syncing schema (symadmin send-schema), if the table has a DATE column, it reads back as TIMESTAMP and SymmetricDS detects it as a data type change. | ||||
| Steps To Reproduce | 1. create table mytest (id integer, create_time date); 2. symadmin send-schema  | ||||
| Tags | ddl/schema, dialect: oracle | ||||
| 
	
	 SymmetricDS: 3.13 c78d7d12 2022-07-20 20:46:56 Details Diff | 
0005368: DDL detects change in column data type for DATE on Oracle | 
Affected Issues 0005368  | 
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/alter/ModelComparator.java | Diff File | ||
| 
	
	 SymmetricDS: 3.14 7b282a05 2022-07-20 20:46:56 Details Diff | 
0005368: DDL detects change in column data type for DATE on Oracle | 
Affected Issues 0005368  | 
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/alter/ModelComparator.java | Diff File | ||
| Date Modified | Username | Field | Change | 
|---|---|---|---|
| 2022-07-20 15:20 | elong | New Issue | |
| 2022-07-20 15:20 | elong | Status | new => assigned | 
| 2022-07-20 15:20 | elong | Assigned To | => elong | 
| 2022-07-20 15:20 | elong | Tag Attached: ddl/schema | |
| 2022-07-20 15:20 | elong | Tag Attached: dialect: oracle | |
| 2022-07-20 20:49 | elong | Status | assigned => resolved | 
| 2022-07-20 20:49 | elong | Resolution | open => fixed | 
| 2022-07-20 20:49 | elong | Fixed in Version | => 3.13.7 | 
| 2022-07-20 21:00 | admin | Changeset attached | => SymmetricDS 3.13 c78d7d12 | 
| 2022-07-20 21:00 | admin | Changeset attached | => SymmetricDS 3.14 7b282a05 | 
| 2022-08-30 13:03 | admin | Status | resolved => closed |