Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

randgen test break by #26545 #27124

Closed
Tracked by #25899
zhouqiang-cl opened this issue Aug 11, 2021 · 2 comments
Closed
Tracked by #25899

randgen test break by #26545 #27124

zhouqiang-cl opened this issue Aug 11, 2021 · 2 comments
Labels
component/test severity/major type/bug The issue is confirmed as a bug.

Comments

@zhouqiang-cl
Copy link
Contributor

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

in ci https://ci.pingcap.net/blue/organizations/jenkins/tidb_ghpr_integration_common_test/detail/tidb_ghpr_integration_common_test/6102/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 zhouqiang-cl added the type/bug The issue is confirmed as a bug. label Aug 11, 2021
@zhouqiang-cl
Copy link
Contributor Author

@ sylzd @XuHuaiyu @ichn-hu PTAL

@zhouqiang-cl zhouqiang-cl mentioned this issue Aug 11, 2021
Closed
@ti-srebot
Copy link
Contributor

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
component/test severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@jingshanglu @zhouqiang-cl @ti-srebot