View Issue Details

IDProjectCategoryView StatusLast Update
0005368SymmetricDSBugpublic2022-07-20 21:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.5.0 
Target Version3.13.7Fixed in Version3.13.7 
Summary0005368: DDL detects change in column data type for DATE on Oracle
DescriptionFor 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 Reproduce1. create table mytest (id integer, create_time date);
2. symadmin send-schema
Tagsddl/schema, dialect: oracle

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.13 c78d7d12

2022-07-20 20:46:56

admin

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

admin

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

Issue History

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