Skip to content

integration_test (ticdc): set global tidb_enable_clustered_index = INT_ONLY before execute any SQL#7534

Merged
ti-chi-bot merged 12 commits intopingcap:masterfrom
asddongmen:dongmen/fix_it
Nov 6, 2022
Merged

integration_test (ticdc): set global tidb_enable_clustered_index = INT_ONLY before execute any SQL#7534
ti-chi-bot merged 12 commits intopingcap:masterfrom
asddongmen:dongmen/fix_it

Conversation

@asddongmen
Copy link
Contributor

@asddongmen asddongmen commented Nov 4, 2022

What problem does this PR solve?

Issue Number: close #7535

What is changed and how it works?

After pingcap/tidb#37384 was merged, tidb_enable_clustered_index is ON by default.
Some TiCDC integration test cases need to drop a table's primary key, but if the primary key is a clustered index, it can't be droped.
This PR set global tidb_enable_clustered_index = INT_ONLY when we connect to upstream TiDB in integration test, which is a workaround to make the integration test cases works as before.

Check List

Tests

  • Integration test

Questions

Will it cause performance regression or break compatibility?
Do you need to update user documentation, design documentation or monitoring documentation?

Release note

None

@ti-chi-bot
Copy link
Member

ti-chi-bot commented Nov 4, 2022

[REVIEW NOTIFICATION]

This pull request has been approved by:

  • amyangfei
  • hi-rustin

To complete the pull request process, please ask the reviewers in the list to review by filling /cc @reviewer in the comment.
After your PR has acquired the required number of LGTMs, you can assign this pull request to the committer in the list by filling /assign @committer in the comment to help you merge this pull request.

The full list of commands accepted by this bot can be found here.

Details

Reviewer can indicate their review by submitting an approval review.
Reviewer can cancel approval by submitting a request changes review.

@ti-chi-bot ti-chi-bot added do-not-merge/needs-linked-issue release-note Denotes a PR that will be considered when it comes time to generate release notes. labels Nov 4, 2022
@asddongmen
Copy link
Contributor Author

/run-integration-tests

@ti-chi-bot ti-chi-bot added the size/XS Denotes a PR that changes 0-9 lines, ignoring generated files. label Nov 4, 2022
@asddongmen
Copy link
Contributor Author

/run-integration-tests

@asddongmen
Copy link
Contributor Author

/run-integration-tests

@asddongmen
Copy link
Contributor Author

/run-integration-tests

@ti-chi-bot
Copy link
Member

@tangenta: Thanks for your review. The bot only counts approvals from reviewers and higher roles in list, but you're still welcome to leave your comments.

Details

In response to this:

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the ti-community-infra/tichi repository.

Copy link
Member

@0xPoe 0xPoe left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks!

other=${*}
fi

prepare="set global tidb_enable_clustered_index = 'int_only';"
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Could you please add a comment for it?

@ti-chi-bot ti-chi-bot added the status/LGT1 Indicates that a PR has LGTM 1. label Nov 5, 2022
@0xPoe
Copy link
Member

0xPoe commented Nov 5, 2022

Please refine your PR title and body. Thanks!

@ti-chi-bot ti-chi-bot added release-note-none Denotes a PR that doesn't merit a release note. and removed release-note Denotes a PR that will be considered when it comes time to generate release notes. labels Nov 6, 2022
@asddongmen asddongmen changed the title Dongmen/fix it integration_test (ticdc): set global tidb_enable_clustered_index = INT_ONLY before execute any SQL Nov 6, 2022
@asddongmen
Copy link
Contributor Author

/run-all-tests

@codecov-commenter
Copy link

codecov-commenter commented Nov 6, 2022

Codecov Report

Merging #7534 (b4ddd72) into master (c0c9a43) will decrease coverage by 0.0109%.
The diff coverage is 56.3845%.

Additional details and impacted files
Flag Coverage Δ
cdc 67.0706% <53.8181%> (-0.3338%) ⬇️
dm 52.0405% <73.3871%> (+0.0247%) ⬆️
engine 61.3492% <60.5882%> (+0.3219%) ⬆️

Flags with carried forward coverage won't be shown. Click here to find out more.

@@               Coverage Diff                @@
##             master      #7534        +/-   ##
================================================
- Coverage   59.8343%   59.8234%   -0.0110%     
================================================
  Files           804        816        +12     
  Lines         92365      93323       +958     
================================================
+ Hits          55266      55829       +563     
- Misses        32287      32648       +361     
- Partials       4812       4846        +34     

@ti-chi-bot ti-chi-bot added status/LGT2 Indicates that a PR has LGTM 2. and removed status/LGT1 Indicates that a PR has LGTM 1. labels Nov 6, 2022
@amyangfei
Copy link
Contributor

/merge

@ti-chi-bot
Copy link
Member

This pull request has been accepted and is ready to merge.

DetailsCommit hash: b4ddd72

@ti-chi-bot ti-chi-bot added the status/can-merge Indicates a PR has been approved by a committer. label Nov 6, 2022
@amyangfei
Copy link
Contributor

/run-check-issue-triage-complete

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

release-note-none Denotes a PR that doesn't merit a release note. size/XS Denotes a PR that changes 0-9 lines, ignoring generated files. status/can-merge Indicates a PR has been approved by a committer. status/LGT2 Indicates that a PR has LGTM 2.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

some integration test cases fail

6 participants