pingcap / pingcap/tidb

lightning: support importing CSV files that contain bool type and value like true/false

Open
#36,998 0 comments 0 reactions 0 assignees View on GitHub
type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Enhancement
We imported csv files which contain bool type fields and values like true/false to TIDB table,the import task finished successfully ,but the values inserted into TiDB table are wrong.
tidb table ddl:
image
csv file:
image
tidb table:
image

Maybe we should transform the data type in csv files or check the data and show warnings or errors before importing instead of inserting wrong values.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.