I am working in a side project to use pt-archiver to normalize tables, I was trying to use it and found out that during the run it will ignore columns during the insert that are camelCase, but it will get all the columns during select, I could see this using dry-run
The solution was to actually include all columns as lower case in the param --columns and it worked, but it took some time to finally find out that.
I have this in my repository : in scripts you can see that I am moving from customers to addresses table.
here is the code that I was running
and here is the result
Environment
None
Activity
Show:
Aaditya Dubey April 19, 2024 at 7:55 AM
Hi
Thank you for the report. Verified as described:
Sending the concern to engineering for further review and fix.
I am working in a side project to use pt-archiver to normalize tables, I was trying to use it and found out that during the run it will ignore columns during the insert that are camelCase, but it will get all the columns during select, I could see this using dry-run
The solution was to actually include all columns as lower case in the param --columns and it worked, but it took some time to finally find out that.
I have this in my repository : in scripts you can see that I am moving from customers to addresses table.
here is the code that I was running
and here is the result