pt-archiver brokes when using output-format=csv and has null values
General
Escalation
General
Escalation
Description
Hi team,
When using output-format=csv on pt-archiver and there are any columns with null values, the import breaks due to the enclosed by '“'.
How to repeat:
Create a table that accepts null on a column and insert some data to it:
Now execute the pt-archiver using the output-format=csv. The output from the file should be similar to the following:
Note that the \N, which stands for NULL, is enclosed by “. When we try to import that file to the same table, we reach the following warning and result on table:
Suggested fix: remove the enclosed by “ when the character is \N(NULL)
Hi team,
When using output-format=csv on pt-archiver and there are any columns with null values, the import breaks due to the enclosed by '“'.
How to repeat:
Create a table that accepts null on a column and insert some data to it:
Now execute the pt-archiver using the output-format=csv. The output from the file should be similar to the following:
Note that the \N, which stands for NULL, is enclosed by “. When we try to import that file to the same table, we reach the following warning and result on table:
Suggested fix: remove the enclosed by “ when the character is \N(NULL)