View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0006267SymmetricDSBugpublic2024-02-28 19:152024-04-19 15:46
Reporteremiller Assigned Toemiller  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.0 
Target Version3.15.4Fixed in Version3.15.4 
Summary0006267: Prevent columns from being created with a size of 0
DescriptionIt's possible for a column to be created with a size of 0. This can result in errors like the one below:

Caused by: Error : 1727, Position : 62, SQL = CREATE TABLE "C##_DBUSER2"."SYM_DATA_"(
    "DATA_ID" NUMBER(0) NOT NULL,
    "TABLE_NAME" VARCHAR2(255) NOT NULL,
    "EVENT_TYPE" CHAR(1) NOT NULL,
    "ROW_DATA" CLOB,
    "PK_DATA" CLOB,
    "OLD_DATA" CLOB,
    "TRIGGER_HIST_ID" NUMBER(0) NOT NULL,
    "CHANNEL_ID" VARCHAR2(128),
    "TRANSACTION_ID" VARCHAR2(255),
    "SOURCE_NODE_ID" VARCHAR2(50),
    "EXTERNAL_DATA" VARCHAR2(50),
    "NODE_LIST" VARCHAR2(255),
    "IS_PREROUTED" NUMBER(1) DEFAULT 0 NOT NULL,
    "CREATE_TIME" TIMESTAMP(6)
), Original SQL = CREATE TABLE "C##_DBUSER2"."SYM_DATA_"(
    "DATA_ID" NUMBER(0) NOT NULL,
    "TABLE_NAME" VARCHAR2(255) NOT NULL,
    "EVENT_TYPE" CHAR(1) NOT NULL,
    "ROW_DATA" CLOB,
    "PK_DATA" CLOB,
    "OLD_DATA" CLOB,
    "TRIGGER_HIST_ID" NUMBER(0) NOT NULL,
    "CHANNEL_ID" VARCHAR2(128),
    "TRANSACTION_ID" VARCHAR2(255),
    "SOURCE_NODE_ID" VARCHAR2(50),
    "EXTERNAL_DATA" VARCHAR2(50),
    "NODE_LIST" VARCHAR2(255),
    "IS_PREROUTED" NUMBER(1) DEFAULT 0 NOT NULL,
    "CREATE_TIME" TIMESTAMP(6)
), Error Message = ORA-01727: numeric precision specifier is out of range (1 to 38)

        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:710)
        ... 31 more
Tagsddl/schema

Relationships

related to 0006266 closedemiller Prevent columns from being created with a size of 0 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 79ffcdb0

2024-03-01 15:31:15

evan-miller-jumpmind

Details Diff 		0006267: Prevented columns from being created with a size of 0 Affected Issues
0006267
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDdlBuilder.java Diff File

Issue History

Date Modified Username Field Change
2024-02-28 19:15 emiller New Issue
2024-02-28 19:15 emiller Status new => assigned
2024-02-28 19:15 emiller Assigned To => emiller
2024-02-28 19:15 emiller Tag Attached: ddl/schema
2024-02-28 19:15 emiller Issue generated from: 0006266
2024-02-28 19:15 emiller Relationship added related to 0006266
2024-03-01 15:31 emiller Status assigned => resolved
2024-03-01 15:31 emiller Resolution open => fixed
2024-03-01 15:31 emiller Fixed in Version => 3.15.4
2024-03-19 16:20 admin Status resolved => closed
2024-04-19 15:46 Changeset attached => SymmetricDS 3.15 79ffcdb0