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

[feature] complete CHECKSUM TABLE Statement #703

Closed
hustjieke opened this issue Nov 12, 2020 · 1 comment
Closed

[feature] complete CHECKSUM TABLE Statement #703

hustjieke opened this issue Nov 12, 2020 · 1 comment
Assignees
@hustjieke
Labels
P0 High priority type: feature wontfix

Comments

@hustjieke
Copy link
Contributor

hustjieke commented Nov 12, 2020 •
edited
Loading

In MySQL 8.0:

CHECKSUM TABLE tbl_name [, tbl_name] ... [QUICK | EXTENDED]

Precautions:
TABLE should be {TABLE | TABLES}, the official doc made a mistake here.
So the correct syntax should be:

CHECKSUM {TABLE | TABLES} tbl_name [, tbl_name] ... [QUICK | EXTENDED]
@hustjieke hustjieke added type: feature P0 High priority labels Nov 12, 2020
@hustjieke hustjieke self-assigned this Nov 12, 2020
hustjieke added a commit to hustjieke/radon that referenced this issue Jan 6, 2021
@hustjieke
*.: complete checksum statement radondb#703
c221a95 
[summary]
1. add [QUICK | EXTENDED] option.
2. fix "checksum/drop TABLE ..." ---> "checksum/drop {TABLE | TABLES} ...".
3. support checksum multi tables.

[test case]
src/planner/others_plan_test.go
src/proxy/checksumtable_test.go

[patch codecov]
src/planner/others_plan.go  91.4%
src/proxy/checksumtable.go  96.9%
@stale
Copy link

stale bot commented Jan 11, 2021

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

@stale stale bot added the wontfix label Jan 11, 2021
BohuTANG added a commit that referenced this issue Jan 13, 2021
@BohuTANG
Merge pull request #715 from hustjieke/feature_complete_checksum_stmt
07f42c3 
*.: complete checksum statement #703
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hustjieke hustjieke

Labels
P0 High priority type: feature wontfix
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@hustjieke