-
Notifications
You must be signed in to change notification settings - Fork 6.1k
Closed
Labels
severity/majorsig/executionSIG executionSIG executiontype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.
Description
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)
2. What did you expect to see? (Required)
3. What did you see instead (Required)
4. What is your TiDB version? (Required)
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
severity/majorsig/executionSIG executionSIG executiontype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.