pt-online-schema-change 3.7.0 lost data when exe alter xxx rename column xxx
General
Escalation
General
Escalation
Description
Environment
None
Activity
Show:
Details
Details
Security Level Help
None
Assignee
Unassigned
UnassignedReporter
starsky
starskyPriority
CriticalComponents
Affects versions
Labels
Needs QA
Yes
Smart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created January 15, 2025 at 1:25 PM
Updated January 15, 2025 at 1:25 PM
pt-online-schema-change 3.7.0 lost data when exe the follower sql，The value of the column col_2 is set to null
alter table t rename column col_1 to col_2;
repeat:
mysql: 8.0+
pt-osc: pt-online-schema-change --no-version-check h=127.0.0.1,u=root,p=xxx,P=xxx,D=sysbench,t=sbtest1 --alter="rename column col_1 to col_2" --execute --statistics