The record of number type cannot be converted(oracle db->online)

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Not a Bug
  • Affects Version/s: CMT8.4.1
  • Fix Version/s: CMT8.4.1
  • Component/s: CUBRID Migration Toolkit
  • Labels:
    None
  • Environment:

    OS:win 7 32bit
    CM:CUBRID 2008 R4.1 (8.4.1.0011) (64bit release build for linux_gnu)
    CMT:Version:R2.0 Build id:2.0.0.5236
    Oracle version: linux.x64_11gR1

Description

1.oracle data:refer to the attachment.
2.do migration(from number type to numeric type)
3.DDL and data
CREATE TABLE "TESTER"."NUMBER_TYPE"
( "MAX_VALUE" NUMBER,
"MAX_VAULE_LESS_ONE" NUMBER,
"MIN_VALUE" NUMBER,
"MIN_VALUE_MORE_ONE" NUMBER,
"NORMAL_VALUE1" NUMBER,
"NORMAL_VALUE2" NUMBER,
"NORMAL_VALUE3" NUMBER,
"OTHER_VALUE" NUMBER
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM" ;

insert into NUMBER_TYPE (MAX_VALUE, MAX_VAULE_LESS_ONE, MIN_VALUE, MIN_VALUE_MORE_ONE, NORMAL_VALUE1, NORMAL_VALUE2, NORMAL_VALUE3, OTHER_VALUE)
values (9E125, 8.9E125, -9E125, -8.9E125, -9E-130, 13232.1112, 0.0011, 0);

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
曹轶麟 added a comment -

Some value is too large for CUBRID.
It's not a bug

Show
曹轶麟 added a comment - Some value is too large for CUBRID. It's not a bug
Hide
Permalink
孙泽玺 added a comment -

the problem will be appear when the data is too large for CUBRID.

Show
孙泽玺 added a comment - the problem will be appear when the data is too large for CUBRID.

People

  • Assignee:
    孙泽玺
    Reporter:
    孙泽玺
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: