ERROR 1105 (HY000): tidb_cast to Int32 is not supported

[fzhedu]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql -h172.16.5.85 -P53324 -uroot -D ssjoin10000

set @@tidb_isolation_level="tiflash";

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

runs ok

3. What did you see instead (Required)

mysql> desc SELECT    table1 . `pk` AS field1 , MIN(  table1 . `pk` ) AS field2 , table1 . `pk` AS field3 , table1 . `col_int` AS field4 , table1 . `col_int` AS field5 FROM  CC AS table1  LEFT  JOIN V AS table2 ON  table1 . `pk` =  table2 . `pk`  WHERE table1 . `pk` < 2  GROUP BY field1, field3, field4, field5 HAVING ((field2 > 9 AND field2 > 1) OR field5 <> 3)  ;
+-----------------------------+---------+--------------+---------------+-----------------------------------------------------------------------------------------------------------------------------------+
| id                          | estRows | task         | access object | operator info                                                                                                                     |
+-----------------------------+---------+--------------+---------------+-----------------------------------------------------------------------------------------------------------------------------------+
| Projection_9                | 1.87    | root         |               | ssjoin10000.cc.pk, cast(ssjoin10000.cc.pk, int(11))->Column#43, ssjoin10000.cc.pk, ssjoin10000.cc.col_int, ssjoin10000.cc.col_int |
| └─TableReader_15            | 1.87    | root         |               | data:Selection_14                                                                                                                 |
|   └─Selection_14            | 1.87    | cop[tiflash] |               | or(and(gt(cast(ssjoin10000.cc.pk, int(11)), 9), gt(cast(ssjoin10000.cc.pk, int(11)), 1)), ne(ssjoin10000.cc.col_int, 3))          |
|     └─TableRangeScan_13     | 16.67   | cop[tiflash] | table:table1  | range:[-inf,2), keep order:false, stats:pseudo                                                                                    |
+-----------------------------+---------+--------------+---------------+-----------------------------------------------------------------------------------------------------------------------------------+
4 rows in set (0.11 sec)

mysql> SELECT    table1 . `pk` AS field1 , MIN(  table1 . `pk` ) AS field2 , table1 . `pk` AS field3 , table1 . `col_int` AS field4 , table1 . `col_int` AS field5 FROM  CC AS table1  LEFT  JOIN V AS table2 ON  table1 . `pk` =  table2 . `pk`  WHERE table1 . `pk` < 2  GROUP BY field1, field3, field4, field5 HAVING ((field2 > 9 AND field2 > 1) OR field5 <> 3)  ;
ERROR 1105 (HY000): tidb_cast to Int32 is not supported

4. What is your TiDB version? (Required)

master of nightly

[fzhedu]

duplicated pingcap/tiflash#1727

[windtalker]

Reopen it since TiDB should not generated implicit cast to cast something to int(11), if TiDB want to cast something to int, int should cast it to bigint(20)

[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.