search

pingcap / dumpling

Dumpling is a fast, easy-to-use tool written by Go for dumping data from the database(MySQL, TiDB...) to local/cloud(S3, GCP...) in multifarious formats(SQL, CSV...).
Apache License 2.0
280 stars 85 forks source link

dump data may be trimmed trailing space #351

Closed lance6716 closed 2 years ago

lance6716 commented 2 years ago

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do? If possible, provide a recipe for reproducing the error.

https://asktug.com/t/topic/153095/9

  1. What did you expect to see?

  2. What did you see instead?

  3. Versions of the cluster

    • Dumpling version (run dumpling -V):

      (paste Dumpling version here)

    • Source database version (execute SELECT version(); in a MySQL client):

      (paste source database version here)

    • Other interesting information (system version, hardware config, etc):

  4. Operation logs

    • Please upload dumpling.log for Dumpling if possible
    • Other interesting logs

  5. Configuration of the cluster and the task

    • running command for Dumpling if possible
kennytm commented 2 years ago

cust_taxcode is a CHAR(20)? VARCHAR(20)?

lichunzhu commented 2 years ago

Can't reproduce in the same environment. According to user's newly added description, it's not a dumpling problem.

不对，应该是我描述有点问题：在使用dumpling导出的时候数据的空格仍然存在，但是在使用 loader 将数据导入到mysql中的时候，空格被trim 掉了