View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0005504SymmetricDSBugpublic2022-10-03 19:482022-10-04 15:15
Reporteremiller Assigned Toemiller  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.0 
Target Version3.14.2Fixed in Version3.14.2 
Summary0005504: Oracle DATE type should not have its size specified
DescriptionWhen importing DDL that includes an Oracle DATE type, the generated SQL will specify the DATE type with its size in parentheses. This is invalid and results in an error. For example, importing the following table results in a MY_DATE column of type DATE(7):

<database xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="dbexport">
  <table name="MY_TABLE">
    <column name="MY_ID" primaryKey="true" required="true" type="DECIMAL" size="19">
      <platform-column name="oracle" type="NUMBER" size="19"/>
    </column>
    <column name="MY_DATE" type="TIMESTAMP" size="7">
      <platform-column name="oracle" type="DATE" size="7"/>
    </column>
  </table>
</database>
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 ac680dd0

2022-10-03 19:49:36

evan-miller-jumpmind

Details Diff 		0005504: Prevented Oracle DATE type from having its size specified Affected Issues
0005504
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/oracle/OracleDdlBuilder.java Diff File

Issue History

Date Modified Username Field Change
2022-10-03 19:48 emiller New Issue
2022-10-03 19:48 emiller Status new => assigned
2022-10-03 19:48 emiller Assigned To => emiller
2022-10-03 19:49 emiller Status assigned => resolved
2022-10-03 19:49 emiller Resolution open => fixed
2022-10-03 19:49 emiller Fixed in Version => 3.14.2
2022-10-03 20:00 Changeset attached => SymmetricDS 3.14 ac680dd0
2022-10-04 15:15 admin Status resolved => closed