View Issue Details

IDProjectCategoryView StatusLast Update
0003835SymmetricDSBugpublic2019-04-25 14:23
ReportermmichalekAssigned Tommichalek 
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.16 
Target Version3.9.16Fixed in Version3.9.16 
Summary0003835: Fix DDL creation of ROWID column for Oracle
DescriptionFix DDL creation of ROWID column for Oracle.

Invalid DDL was being generated (see below). The ROWID should not specify the size - ie, remove the "(10):.

BAD DDL:
2018-12-19 10:23:14,146 INFO [] [OracleDatabasePlatform] [main] Running alter sql:
CREATE TABLE "TEST_TYPES"(
    "COL0" NCHAR(5),
    "COL1" NVARCHAR2(1000),
    "COL2" VARCHAR2(100),
    "COL3" NUMBER,
    "COL4" BINARY_FLOAT,
    "COL5" BINARY_DOUBLE,
    "COL6" DATE,
    "COL7" TIMESTAMP(6) WITH TIME ZONE,
    "COL8" TIMESTAMP(6) WITH LOCAL TIME ZONE,
    "COL9" NCLOB,
    "COL10" ROWID(10),
    "COL11" XMLTYPE,
    "COL12" NUMBER
);

GOOD DDL:
2018-12-19 10:23:14,146 INFO [] [OracleDatabasePlatform] [main] Running alter sql:
CREATE TABLE "TEST_TYPES"(
    "COL0" NCHAR(5),
    "COL1" NVARCHAR2(1000),
    "COL2" VARCHAR2(100),
    "COL3" NUMBER,
    "COL4" BINARY_FLOAT,
    "COL5" BINARY_DOUBLE,
    "COL6" DATE,
    "COL7" TIMESTAMP(6) WITH TIME ZONE,
    "COL8" TIMESTAMP(6) WITH LOCAL TIME ZONE,
    "COL9" NCLOB,
    "COL10" ROWID,
    "COL11" XMLTYPE,
    "COL12" NUMBER
);
TagsNo tags attached.

Relationships

related to 0003836 closedmmichalek Fix DDL creation of ROWID column for Oracle (3.10) 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 a5712725

2018-12-19 10:26:49

mmichalek

Details Diff
0003835: Fix DDL creation of ROWID column for Oracle
0003835
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/oracle/OracleDdlBuilder.java Diff File

Issue History

Date Modified Username Field Change
2018-12-19 10:26 mmichalek New Issue
2018-12-19 10:26 mmichalek Status new => assigned
2018-12-19 10:26 mmichalek Assigned To => mmichalek
2018-12-19 10:28 mmichalek Issue cloned: 0003836
2018-12-19 10:29 mmichalek Relationship added related to 0003836
2018-12-19 11:00 mmichalek Changeset attached => SymmetricDS 3.9 a5712725
2019-04-25 14:23 elong Status assigned => closed
2019-04-25 14:23 elong Resolution open => fixed
2019-04-25 14:23 elong Fixed in Version => 3.9.16