Ambiguous warning when multiply result out of range

[zhangysh1995]

Description

Bug Report

It should return a clear error message regarding the original expression.

1. Minimal reproduce step (Required)

drop table if exists t5;
create table t5 (col0 CHAR(204), col1 VARBINARY(105), col2 TIMESTAMP, col3 TEXT, col4 FLOAT, col5 INT, col6 DOUBLE, col7 BIGINT, col8 BINARY(166), col9 DATETIME);
insert into t5 values ('73d6f787-e7d5-4238-97a2-fe789e18c2fd', '1101001', '1970-01-04 00:00:01', 'x', '86.5241691045369', '-0', '261.3998105809103', '-9223372036854775807', '100111', '1000-01-02 00:00:00');
create index dlzae on t5 (col7, col2);
SELECT col3 from t5 where t5.col7 * ABS(-9223372036854775807) ;

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

Clear error message about the out of range.

mysql> SELECT col3 from t5 where t5.col7 * ABS(-9223372036807) ;
ERROR 1690 (22003): BIGINT value is out of range in '(`test`.`t5`.`col7` * <cache>(abs(-(9223372036807))))'

3. What did you see instead (Required)

What is Column#0?

mysql> SELECT col3 from t5 where t5.col7 * ABS(-9223372036854775807) ;
ERROR 1690 (22003): BIGINT value is out of range in '(Column#0 * 9223372036854775807)'

4. Affected version (Required)

commit 4e74d40392e9b81f2a90cbc2f7777fd35f87b2e7 (HEAD -> master, origin/master, origin/HEAD)
Author: Arenatlx <ailinsilence4@gmail.com>
Date:   Fri Jun 12 16:58:00 2020 +0800

5. Root Cause Analysis

SIG slack channel

#sig-exec

Score

• 300

Mentor

• @qw4990

[g1eny0ung]

/label component/expression

[yufan022]

/pick-up

[ti-challenge-bot]

It is not a pickable issue!

[zhangysh1995]

@yufan022 I think you may propose a PR directly? The challenge program has finished. You will need to follow the contribution guidelines for TiDB.

[yufan022]

/pick-up

[ti-challenge-bot]

Pick up success.

[yufan022]

/give-up

[ti-challenge-bot]

Give up success.

[yufan022]

@yufan022 I think you may propose a PR directly? The challenge program has finished. You will need to follow the contribution guidelines for TiDB.

mockstore can't get column name, no good idea. maybe need discuss.

[XuHuaiyu]

Error message or error code does not match MySQL

It should be considered as a minor bug.