[Feature Request] Skip some columns when copying rows to new table.
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
Hi.
Thanks for your useful tools, especially pt-online-
I have a small feature request which really useful when not to copy some columns to new table.
Let's say we have below table and some rows.
CREATE TABLE test (id int primary key, fd1 char(1) not null default 'Y');
==> and this table's most of row have 'Y' value on fd1 column.
On this table, If I want to change "DEFAULT 'N'" on fd1 column and want to set 'N' to fd1 column of all rows.
This is possible when I use ALTER TABLE command like this.
==> ALTER TABLE test DROP fd1, ADD fd1 CHAR(1) NOT NULL DEFAULT 'N';
But, with pt-online-
So, pt-online-
If pt-online-
shell> pt-online-
I believe you can easily implement it. And some people really want to this feature.
Thanks again.
tags: | added: pt-online-schema-change |
I modified pt-online- schema- change tool a little bit.
And you can see that from blog site.
http:// kakaodbe. blogspot. kr/2014/ 04/pt-online- schema- change- modified- pt.html