[CMT2][BUG]When migrate varbinary(65532) to bit varying, the big value cannot be migrated.

Details

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

    CMT2.0.0.4890

Description

1 Create one table use the sql as attachment.
2 Do migration

Actual result:
The big value which length is 65532 doesn't be migrated.

  1. File
    varbinary_type.sql
    13/Dec/11 10:01 PM
    65 kB
    高艳铭
  1. lessdata.PNG
    51 kB
    05/Jan/12 12:39 AM
  2. varbinary.PNG
    46 kB
    13/Dec/11 10:01 PM

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
高艳铭 added a comment -

From xml to cubrid, the bug exist too.

Show
高艳铭 added a comment - From xml to cubrid, the bug exist too.
Hide
Permalink
曹轶麟 added a comment -

This not a bug, the data has been inserted into the DB.
Just the data is too large to be displayed.

And There has been a issue about XML.

So, it can be closed.

Show
曹轶麟 added a comment - This not a bug, the data has been inserted into the DB. Just the data is too large to be displayed. And There has been a issue about XML. So, it can be closed.
Hide
Permalink
高艳铭 added a comment -

I cannot migrated any record in varbinary_type to target db.

mysql+online

Show
高艳铭 added a comment - I cannot migrated any record in varbinary_type to target db. mysql+online
Hide
Permalink
孙泽玺 added a comment -

this problem exists in the version of cmt2.0.0.5131 too. Please examines this situation and give appropriate information.

Show
孙泽玺 added a comment - this problem exists in the version of cmt2.0.0.5131 too. Please examines this situation and give appropriate information.
Hide
Permalink
曹轶麟 added a comment -

It is a bug of cubrid jdbc's prepare statement.

Show
曹轶麟 added a comment - It is a bug of cubrid jdbc's prepare statement.
Hide
Permalink
曹轶麟 added a comment -

Move to 2.0.1

Show
曹轶麟 added a comment - Move to 2.0.1
Hide
Permalink
曹轶麟 added a comment -

The byte[] object returned by MySQL's driver can not used by CUBRID JDBC driver directly, so we must create a copy of the byte[] before call the method "setBytes" of CUBRID JDBC driver.It's very strange.

Show
曹轶麟 added a comment - The byte[] object returned by MySQL's driver can not used by CUBRID JDBC driver directly, so we must create a copy of the byte[] before call the method "setBytes" of CUBRID JDBC driver.It's very strange.
Hide
Permalink
高艳铭 added a comment -

Regression result:(in CMT2.0.0.5209)
Migrated firstly, it's ok.
Migrated again, it only migrated some character.

Please see the attachment.

Show
高艳铭 added a comment - Regression result:(in CMT2.0.0.5209) Migrated firstly, it's ok. Migrated again, it only migrated some character. Please see the attachment.
Hide
Permalink
曹轶麟 added a comment -

fixed

Show
曹轶麟 added a comment - fixed
Hide
Permalink
高艳铭 added a comment -

Fix in CMT8.4.1.0001 20120120

Show
高艳铭 added a comment - Fix in CMT8.4.1.0001 20120120

People

  • Assignee:
    高艳铭
    Reporter:
    高艳铭
Vote (0)
Watch (0)

Dates

  • Due:
    Created:
    Updated:
    Resolved: