The primary key can not be created when migrating mysql db to offline db..

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Trivial Trivial
  • Resolution: Fixed
  • 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)
    Mysql server version: 5.5.18
    Version:2008 R4.1 Build id:8.4.1.0001(20120119)

Description

1. mysql data:refer to the attachment.
2. go to step 3, select the first three fields of the table "agent", do migration, then check the logs.
3. create the primary key using command "ALTER /*+ NO_STATS */ TABLE "agent" ADD PRIMARY KEY("agent_id");", and it is successful.
4. do migration using form DB->offline, go to step 3,select the two table "agent" and "agent_group", then check the logs, you will find creating primary key is successful, and will find the DDL of creating it.

  1. File
    agent_group.sql
    19/Jan/12 8:13 PM
    2 kB
    孙泽玺
  2. File
    agent.sql
    19/Jan/12 8:13 PM
    3 kB
    孙泽玺
  1. bug103-primary_key_error_1.png
    74 kB
    19/Jan/12 5:33 AM
  2. bug103-primary_key_error_2.png
    64 kB
    19/Jan/12 5:33 AM
  3. bug103-primary_key_error_3.png
    55 kB
    19/Jan/12 5:33 AM

Activity

Hide
Permalink
孙泽玺 added a comment -

there is no "offline" in the version cmt8.4.1.0001(20120120)

Show
孙泽玺 added a comment - there is no "offline" in the version cmt8.4.1.0001(20120120)

People

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

Dates

  • Created:
    Updated:
    Resolved: