enum value convert to float failed

[ChenPeng2013]

Development Task

Fix bug:

1. Minimal reproduce step (Required)

use test;
drop table if exists t;
create table t(a enum('a', 'b', 'c'));
insert into t values(1), (2), (3);
select * from t where a;
show warnings;

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

mysql> select * from t where a;
+------+
| a    |
+------+
| a    |
| b    |
| c    |
+------+
3 rows in set (0.00 sec)

mysql> show warnings;
Empty set (0.00 sec)

3. What did you see instead (Required)

mysql> select * from t where a;                                                                                                                Empty set, 3 warnings (0.00 sec)

mysql> show warnings;
+---------+------+--------------------------------------+
| Level   | Code | Message                              |
+---------+------+--------------------------------------+
| Warning | 1292 | Truncated incorrect FLOAT value: 'a' |
| Warning | 1292 | Truncated incorrect FLOAT value: 'b' |
| Warning | 1292 | Truncated incorrect FLOAT value: 'c' |
+---------+------+--------------------------------------+
3 rows in set (0.00 sec)

4. What is your TiDB version? (Required)

master 462927b and release-4.0 476c992

Please comment on this issue if you are interested in.

SIG slack channel

#sig-exec

Score

• 300

Mentor

• @XuHuaiyu

[ChenPeng2013]

set value convert to float failed

use test;
drop table if exists t;
create table t(a set('a', 'b', 'c'));
insert into t values(3);
select * from t where a;
show warnings;

expect

mysql> select * from t where a;
+------+
| a    |
+------+
| a,b  |
+------+
1 row in set (0.00 sec)

mysql> show warnings;
Empty set (0.00 sec)

got

mysql> select * from t where a;
Empty set, 1 warning (0.00 sec)

mysql> show warnings;
+---------+------+----------------------------------------+
| Level   | Code | Message                                |
+---------+------+----------------------------------------+
| Warning | 1292 | Truncated incorrect FLOAT value: 'a,b' |
+---------+------+----------------------------------------+
1 row in set (0.00 sec)

[ti-challenge-bot]

This issue does not belong to any SIG.

More

Tip : Currently, we only support sig labels starting with sig/, maybe you should add this type of label.

Warning: None

[XuHuaiyu]

/pick-up

[ti-challenge-bot]

Pick up success.

[XuHuaiyu]

/give-up

[ti-challenge-bot]

Give up success.

[ti-challenge-bot]

The issue has been removed from the challenge program.

[ti-challenge-bot]

The issue has been removed from the challenge program.

[xiaodong-ji]

/pick-up

[ti-challenge-bot]

Pick up success.

[sre-bot]

Integrity check:
RCA symptom trigger_condition affect_version fix_version fields are empty

Please comment /info to get template

[ti-srebot]

Please edit this comment to complete the following information

Not a bug

1. Remove the 'type/bug' label
2. Add notes to indicate why it is not a bug

Duplicate bug

1. Add the 'type/duplicate' label
2. Add the link to the original bug

Bug

Note: Make Sure that 'component', and 'severity' labels are added
Example for how to fill out the template: #20100

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

6. Fixed versions

[ti-srebot]

( FixedVersions AffectedVersions ) fields are empty.