[CMT8.4.1.201211]When migrate bigint to csv, the data has been changed.

Details

Description

1 Create one table which sql is in attachment(bigintandint.sql) in mysql.
2 Do migration from mysql to csv

Actual result:
18446744073709551615 became to 18446744073709550000

  1. File
    floattest.sql
    29/Oct/12 6:35 AM
    2 kB
    高艳铭
  1. bigint.PNG
    33 kB
    29/Oct/12 4:49 AM

Activity

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

I have confirmed bigint is excel problem.

But the float data type has error.
Create one table use the sql in attachment.
Do migration to csv, the data has changed.

Show
高艳铭 added a comment - - edited I have confirmed bigint is excel problem. But the float data type has error. Create one table use the sql in attachment. Do migration to csv, the data has changed.
Hide
Permalink
曹轶麟 added a comment -

The issue about bigint is a bug of excel.

The float issue, please refer to TOOLS-2162

Show
曹轶麟 added a comment - The issue about bigint is a bug of excel. The float issue, please refer to TOOLS-2162
Hide
Permalink
高艳铭 added a comment -

Closed in CMT8.4.1.3088

Show
高艳铭 added a comment - Closed in CMT8.4.1.3088

People

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

Dates

  • Due:
    Created:
    Updated:
    Resolved:

Time Tracking

Estimated:
Not Specified
Original Estimate - Not Specified
Remaining:
0m
Remaining Estimate - 0 minutes
Logged:
1h
Time Spent - 1 hour