SubstringUTF8 & RightUTF8 do not support length of integer types other than int64/uint64 #9473
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
mysql> CREATE TABLE `t` ( `id`varchar(20), `lgth`tinyint(10) );
Query OK, 0 rows affected (0.04 sec)
mysql> alter table t set tiflash replica 1;
Query OK, 0 rows affected (0.08 sec)
mysql> explain select left(id, lgth) from t;
+----------------------------+----------+--------------+---------------+----------------------------------------+
| id | estRows | task | access object | operator info |
+----------------------------+----------+--------------+---------------+----------------------------------------+
| TableReader_12 | 10000.00 | root | | MppVersion: 2, data:ExchangeSender_11 |
| └─ExchangeSender_11 | 10000.00 | mpp[tiflash] | | ExchangeType: PassThrough |
| └─Projection_4 | 10000.00 | mpp[tiflash] | | left(test.t.id, test.t.lgth)->Column#4 |
| └─TableFullScan_10 | 10000.00 | mpp[tiflash] | table:t | keep order:false, stats:pseudo |
+----------------------------+----------+--------------+---------------+----------------------------------------+
4 rows in set, 1 warning (0.01 sec)
mysql> show warnings;
+---------+------+---------------------------------------------------------------------------------------------------------------------+
| Level | Code | Message |
+---------+------+---------------------------------------------------------------------------------------------------------------------+
| Warning | 1105 | Scalar function 'left'(signature: LeftUTF8, return type: var_string(20)) is not supported to push down to tikv now. |
+---------+------+---------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> explain analyze select left(id, lgth) from t;
ERROR 1105 (HY000): other error for mpp stream: Code: 0, e.displayText() = DB::Exception: 3nd argument of function substringUTF8 must have UInt/Int type., e.what() = DB::Exception,2. What did you expect to see? (Required)
No error.
3. What did you see instead (Required)
Error.
4. What is your TiFlash version? (Required)
master