“ Unexpected ExprType Float64 and EvalType Int” while using cluster index

[aytrack]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE `PK_S_MULTI_42_2` (  `COL1` year(4) NOT NULL,  `COL2` year(4) NOT NULL,  `COL3` year(4) DEFAULT NULL,  PRIMARY KEY (`COL1`,`COL2`) clustered);
select * from PK_S_MULTI_42 where col2 between 2154 and 2154 AND col3 > 2153;

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

execute successfully without error

3. What did you see instead (Required)

mysql > CREATE TABLE `PK_S_MULTI_42_2` (  `COL1` year(4) NOT NULL,  `COL2` year(4) NOT NULL,  `COL3` year(4) DEFAULT NULL,  PRIMARY KEY (`COL1`,`COL2`) clustered);
Query OK, 0 rows affected
Time: 0.282s
mysql > select * from PK_S_MULTI_42_2 where col2 between 2154 and 2154 AND col3 > 2153;
(1105, 'other error: [components/tidb_query_expr/src/types/expr_builder.rs:357]: Unexpected ExprType Float64 and EvalType Int')

mysql > CREATE TABLE `PK_S_MULTI_42_1` (  `COL1` year(4) NOT NULL,  `COL2` year(4) NOT NULL,  `COL3` year(4) DEFAULT NULL,  PRIMARY KEY (`COL1`,`COL2`) nonclustered);
Query OK, 0 rows affected
Time: 0.305s
mysql > select * from PK_S_MULTI_42_1 where col2 between 2154 and 2154 AND col3 > 2153;
+------+------+------+
| COL1 | COL2 | COL3 |
+------+------+------+

4. What is your TiDB version? (Required)

master: fd706ab

[XuHuaiyu]

A bug related to clustered index, thus I change from sig/sql-infra to sig/execution

[lysu]

@XuHuaiyu this bug isn't releated to clustered index, it caused by #20338 and related to executor

[ti-srebot]

Please edit this comment or add a new 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