View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0006266SymmetricDSBugpublic2024-02-28 19:142024-04-19 15:46
Reporteremiller Assigned Toemiller  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.0 
Target Version3.14.13Fixed in Version3.14.13 
Summary0006266: 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 0006267 closedemiller Prevent columns from being created with a size of 0 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 c4f4fc63

2024-03-01 16:10:42

evan-miller-jumpmind

Details Diff 		0006266: Prevented columns from being created with a size of 0 Affected Issues
0006266
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:14 emiller New Issue
2024-02-28 19:14 emiller Status new => assigned
2024-02-28 19:14 emiller Assigned To => emiller
2024-02-28 19:14 emiller Tag Attached: ddl/schema
2024-02-28 19:15 emiller Issue cloned: 0006267
2024-02-28 19:15 emiller Relationship added related to 0006267
2024-03-01 16:11 emiller Status assigned => resolved
2024-03-01 16:11 emiller Resolution open => fixed
2024-03-01 16:11 emiller Fixed in Version => 3.14.13
2024-03-19 16:20 admin Status resolved => closed
2024-04-19 15:46 Changeset attached => SymmetricDS 3.14 c4f4fc63