[jira] [Created] (IGNITE-1158) Duplicate Field when creating using Apache Ignite Schema Import utility

[Anton Vinogradov (Jira)]

Alexey Kuznetsov created IGNITE-1158:
----------------------------------------

             Summary: Duplicate Field when creating using Apache Ignite Schema Import utility
                 Key: IGNITE-1158
                 URL: https://issues.apache.org/jira/browse/IGNITE-1158
             Project: Ignite
          Issue Type: Bug
          Components: general
    Affects Versions: 1.1.4
            Reporter: Alexey Kuznetsov
            Assignee: Alexey Kuznetsov
             Fix For: sprint-8



I am creating the cache using Apache Ignite Schema Import utility.  But it
is generating me duplicate fields for my values.

public class ModelFieldStaticdata implements Serializable {
    /** */
    private static final long serialVersionUID = 0L;

    /** Value for modelFieldStaticdataOid. */
    private java.math.BigDecimal modelFieldStaticdataOid;

    /** Value for modelFieldStaticdataOid. */
    private java.math.BigDecimal modelFieldStaticdataOid;

    /** Value for modelFieldStaticdataOid. */
    private java.math.BigDecimal modelFieldStaticdataOid;

    /** Value for modelFieldStaticdataOid. */
    private java.math.BigDecimal modelFieldStaticdataOid;

    /** Value for modelFieldStaticdataOid. */
    private java.math.BigDecimal modelFieldStaticdataOid;

    /** Value for modelFieldStaticdataOid. */
    private java.math.BigDecimal modelFieldStaticdataOid;

I am using oracle sql developer 4.1.1.19 and the driver is ojdbc 6.1. The
script to create table is as follows

CREATE TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER"
   (    "EXCEPTION_ID" VARCHAR2(100 CHAR),
        "EXCEPTION_CREATED_DATE" DATE,
        "EXCEPTION_PROCESSING_DATE" DATE,
        "EXCEPTION_COMPLETION_DATE" DATE,
        "EXCEPTION_PRIORITY" VARCHAR2(30 CHAR),
        "EXCEPTION_SEVERITY" VARCHAR2(30 CHAR),
        "GEOGRAPHY_ID" NUMBER(30,0),
        "COUNTRY_ID" NUMBER,
        "BRANCH_ID" NUMBER,
        "L1L2STATUS" VARCHAR2(50 CHAR),
        "SERVICE_LEVEL" VARCHAR2(100 CHAR),
        "RECONCILIATION_TYPE" VARCHAR2(30 CHAR),
        "UPDATED_BY" VARCHAR2(30 CHAR),
        "UPDATED_DATE" TIMESTAMP (6),
        "SESSION_ID" VARCHAR2(80 BYTE),
        "RECORD_END_DATE" TIMESTAMP (6),
        "RECORD_STATUS" VARCHAR2(10 CHAR),
        "CREATED_DATE" TIMESTAMP (6),
        "EXCEPTION_CATEGORY" VARCHAR2(32 BYTE),
        "EXCEPTION_DESCRIPTION" VARCHAR2(180 BYTE),
        "EXCEPTION_OID" NUMBER(30,0),
        "EXCEPTION_STATUS" VARCHAR2(32 BYTE),
        "EXCEPTION_TYPE_ID" NUMBER(30,0),
        "FUNCTIONAL_AREA_ID" NUMBER(30,0),
        "IPADDRESS" VARCHAR2(39 BYTE),
        "PRODUCTLINE_ID" NUMBER(30,0),
        "RECON_ID" VARCHAR2(32 BYTE),
        "RECORD_VERSION" NUMBER(6,0),
        "CREATED_BY" VARCHAR2(32 BYTE),
        "LINK_ID" NUMBER(30,0),
        "BUSINESS_CONTEXT_ID" VARCHAR2(32 CHAR),
        "RECON_EXECUTION_ID" NUMBER(30,0),
        "BUSINESS_PROCESS_ID" VARCHAR2(32 BYTE),
        "MANUAL_ENTRY_FLAG" VARCHAR2(12 BYTE),
        "PROCESSING_TYPE" VARCHAR2(32 BYTE),
        "ASSET_CLASS_ID" VARCHAR2(32 BYTE),
        "TRADE_DATE" DATE,
        "PARENT_EXCEPTION_ID" VARCHAR2(100 BYTE),
        "MERGED_EXCEPTION_ID" VARCHAR2(100 CHAR),
        "GROUPED_EXCEPTION_ID" VARCHAR2(100 CHAR),
        "EXCEPTION_GROUP_INDICATOR" VARCHAR2(10 CHAR),
        "TOTAL_OUTSTANDING_AMOUNT" NUMBER(12,2),
        "CLEARING_DATE" DATE,
        "REASON_CODE" VARCHAR2(32 CHAR),
        "COMMENTS" VARCHAR2(2000 CHAR),
        "EXCEPTION_AUTHORIZATION_STATUS" VARCHAR2(32 CHAR),
        "SUSPENSE_ENTRY_FLAG" VARCHAR2(10 CHAR)
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 52428800 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  DDL for Index EXCEPTION_MASTER_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER_PK" ON
"ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" ("EXCEPTION_OID")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  Constraints for Table EXCEPTION_MASTER
--------------------------------------------------------

  ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" ADD CONSTRAINT
"EXCEPTION_MASTER_PK" PRIMARY KEY ("EXCEPTION_OID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE;

  ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("EXCEPTION_ID" NOT NULL ENABLE);

  ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("RECORD_STATUS" NOT NULL ENABLE);

  ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("CREATED_DATE" NOT NULL ENABLE);

  ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("EXCEPTION_OID" NOT NULL ENABLE);

  ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("EXCEPTION_STATUS" NOT NULL ENABLE);

  ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY ("IPADDRESS"
NOT NULL ENABLE);

  ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("RECORD_VERSION" NOT NULL ENABLE);

  ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY ("CREATED_BY"
NOT NULL ENABLE);

  ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY ("LINK_ID"
NOT NULL ENABLE);

  ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("BUSINESS_CONTEXT_ID" NOT NULL ENABLE);

  ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("RECON_EXECUTION_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  DDL for Trigger EXCEPTION_OID_TRIGGER
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "ALGORECONUTILITY_DEV"."EXCEPTION_OID_TRIGGER"
before
INSERT ON "EXCEPTION_MASTER" FOR EACH row BEGIN IF inserting THEN
SELECT EXCEPTION_MASTER_SEQ.nextval INTO :NEW."EXCEPTION_OID" FROM dual;
END IF;
END;






/
ALTER TRIGGER "ALGORECONUTILITY_DEV"."EXCEPTION_OID_TRIGGER" DISABLE;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)