-
Notifications
You must be signed in to change notification settings - Fork 6.1k
Closed
Labels
component/testseverity/majortype/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!
[2021-08-11T11:54:25.941Z] 2021/08/11 19:54:25.399 [fatal] run test [udaf_bitand_union] err: sql:select bit_and(`col_float_unsigned_key`) as a from (select * from `table20_int_autoinc` union all select * from `table40_int_autoinc`) tmp group by tmp.`col_double_signed_key`, tmp.`col_decimal_6_3_signed` order by a;: failed to run query
[2021-08-11T11:54:25.942Z] "select bit_and(`col_float_unsigned_key`) as a from (select * from `table20_int_autoinc` union all select * from `table40_int_autoinc`) tmp group by tmp.`col_double_signed_key`, tmp.`col_decimal_6_3_signed` order by a;"
[2021-08-11T11:54:25.942Z] around line 555,
[2021-08-11T11:54:25.942Z] we need(439):
[2021-08-11T11:54:25.942Z] select bit_and(`col_float_unsigned_key`) as a from (select * from `table20_int_autoinc` union all select * from `table40_int_autoinc`) tmp group by tmp.`col_double_signed_key`, tmp.`col_decimal_6_3_signed` order by a;
[2021-08-11T11:54:25.942Z] a
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 47
[2021-08-11T11:54:25.942Z] select bit_and(`col_double_unsigned_key`) as a from (select * from `table40_int_autoinc` union all select * from `
[2021-08-11T11:54:25.942Z] but got(439):
[2021-08-11T11:54:25.942Z] select bit_and(`col_float_unsigned_key`) as a from (select * from `table20_int_autoinc` union all select * from `table40_int_autoinc`) tmp group by tmp.`col_double_signed_key`, tmp.`col_decimal_6_3_signed` order by a;
[2021-08-11T11:54:25.942Z] a
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 0
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 1
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 13
[2021-08-11T11:54:25.942Z] 47
[2021-08-11T11:54:25.942Z] 18446744073709551505
[2021-08-11T11:54:25.942Z] 18446744073709551505
[2021-08-11T11:54:25.942Z] 18446744073709551560
[2021-08-11T11:54:25.942Z] 18446744073709551607
[2021-08-11T11:54:25.942Z] 18446744073709551607
[2021-08-11T11:54:25.942Z] 18446744073709551615
[2021-08-11T11:54:25.942Z]
[2021-08-11T11:54:25.942Z]
1. Minimal reproduce step (Required)
introduce in #26545
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
component/testseverity/majortype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.