Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

load data with same field and line term value lead to miss rows #22598

Open
lysu opened this issue Jan 28, 2021 · 1 comment
Open

load data with same field and line term value lead to miss rows #22598

lysu opened this issue Jan 28, 2021 · 1 comment
Labels
severity/minor sig/transaction SIG:Transaction type/bug The issue is confirmed as a bug.

Comments

@lysu
Copy link
Contributor

lysu commented Jan 28, 2021

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t(a int, b int);

load data

1|2|3

into t.

2. What did you expect to see? (Required)

with fields terminated by '|' lines terminated by '\n', result should be

row1: 1 2

with fields terminated by '|' lines terminated by '|', result should be

row1: 1 2
row2: 3 <nil>

3. What did you see instead (Required)

with fields terminated by '|' lines terminated by '|' got:

row1: 1 2

in master and 5.0

row1: 1 <nil>
row2: 2 <nil>
row3: 3 <nil>

in 4.0.x or before

4. What is your TiDB version? (Required)

4.0.10
5.0.rc
master

@lysu lysu added type/bug The issue is confirmed as a bug. severity/moderate labels Jan 28, 2021
@buggithubs buggithubs added the sig/execution SIG execution label Jan 28, 2021
@XuHuaiyu XuHuaiyu added sig/sql-infra SIG: SQL Infra and removed sig/execution SIG execution labels Feb 18, 2021
@bb7133 bb7133 added sig/transaction SIG:Transaction and removed sig/sql-infra SIG: SQL Infra labels Dec 8, 2021
@zyguan
Copy link
Contributor

zyguan commented Dec 30, 2021

Decrease the severity since it's not a common usage.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/minor sig/transaction SIG:Transaction type/bug The issue is confirmed as a bug.
Projects
None yet
Development

No branches or pull requests

5 participants