Integration test break by #25766

[zhouqiang-cl]

Bug Report

Please answer these questions before submitting your issue. Thanks!
from or #25766

[2021-07-07T07:32:52.428Z] cast(greatest(a, b, c, d, e, f, g) as DECIMAL(65,20))

[2021-07-07T07:32:52.428Z] 18704.00000000000000000000

[2021-07-07T07:32:52.428Z] 455145037341130752.00000000000000000000

[2021-07-07T07:32:52.428Z] 47.00000000000000000000

[2021-07-07T07:32:52.428Z] NULL

[2021-07-07T07:32:52.428Z] 66.00000000000000000000

[2021-07-07T07:32:52.428Z] 24498.00000000000000000000

[2021-07-07T07:32:52.428Z] NULL

[2021-07-07T07:32:52.428Z] NULL

[2021-07-07T07:32:52.428Z] NULL

[2021-07-07T07:32:52.428Z] NULL

[2021-07-07T07:32:52.428Z] SELECT cast(greate

[2021-07-07T07:32:52.428Z] but got(584):

[2021-07-07T07:32:52.428Z] SELECT cast(greatest(a, b, c, d, e, f, g) as DECIMAL(65,20)) FROM (SELECT `col_decimal_40_20_unsigned_key` AS a, `col_decimal_10_4_unsigned` AS b, `col_bigint_signed_key` AS c, `col_bigint_unsigned_key` AS d, `col_decimal_10_4_signed_key` AS e, `col_decimal_10_4_signed` AS f, `col_decimal_6_3_signed_key` AS g FROM `table10_int_autoinc` ) tmp;

[2021-07-07T07:32:52.428Z] cast(greatest(a, b, c, d, e, f, g) as DECIMAL(65,20))

[2021-07-07T07:32:52.428Z] 18704.00000000000000000000

[2021-07-07T07:32:52.428Z] 455145037341130752.00000000000000000000

[2021-07-07T07:32:52.428Z] 47.00000000000000000000

[2021-07-07T07:32:52.428Z] NULL

[2021-07-07T07:32:52.429Z] 66000000000000000000.00000000000000000000

[2021-07-07T07:32:52.429Z] 24498.00000000000000000000

[2021-07-07T07:32:52.429Z] NULL

[2021-07-07T07:32:52.429Z] NULL

[2021-07-07T07:32:52.429Z] NULL

[2021-07-07T07:32:52.429Z] NULL

[2021-07-07T07:32:52.429Z] 

1. Minimal reproduce step (Required)

in ci https://ci.pingcap.net/blue/organizations/jenkins/tidb_ghpr_common_test/detail/tidb_ghpr_common_test/5363/pipeline

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

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

[zhouqiang-cl]

@lzmhhh123

[zhouqiang-cl]

@ichn-hu

[tisonkun]

Hi @zhouqiang-cl is it an instance of #25899?

[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