Dump table stats error on wrong enum values

[pcqz]

Description

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

use test;
drop table if exists t;
create table t (id serial, field ENUM('Y','N') DEFAULT 'N');
insert into t values(1,'A');
analyze table t;

curl ${tidb-server-ip}:${tidb-server-status-port}/stats/dump/test/t

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

Dump stats successfully with no error.

3. What did you see instead (Required)

convert to MySQL enum failed: item is not in enum [Y N]: [types:1265]Data truncated for column '%s' at row %d

4. What is your TiDB version? (Required)

release-4.0

SIG slack channel

#sig-exec

Score

300

Mentor

• @lzmhhh123

[clark1013]

/assign

[rickyyx]

Is it fixed already or still a bug?

I am seeing almost identical behaviour on current master 4b90ef4 with MySQL. (Just that analyze doesn't produce a table on TiDB, but does on MySQL, which seems not to be the concern of this issue).

[jianzhiyao]

Can't reproduce in TiDB 5.0.
PTAL @ichn-hu

use test
> OK
> 时间: 0.001s


drop table if exists t
> OK
> 时间: 0.012s


create table t (id serial, a ENUM('Y','N') DEFAULT 'N')
> OK
> 时间: 0.007s


insert into t values(1,'A')
> 1265 - Data truncated for column 'a' at row 1
> 时间: 0.002s

[yudongusa]

@pcqz it seems the problem was already fixed, would you please verify and close if no further issues?

[github-actions]

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.