antares-sql
Export as CSV behaved strangely when one column contains perl code
We have a table used by a web server for segregating HTTP traffic into "human" and "robot" actors. One column of this table contains perl code that is executed to analyze the User-Agent string. When exporting values from this table with "Export as CSV", the resulting file has columns separated by semicolons instead of commas, and does not properly quote the semicolons embedded in the perl code, resulting in a corrupted file.
To Reproduce Steps to reproduce the behavior:
- Use the attached JSON export (named .txt as github will not accept a .json file extension) to populate a table.
SELECT *from that table- Choose Export as CSV
- Examine resulting output file
Expected behavior File should have comma-separated values, with properly quoted column data, or at least have a usable separator other than something that appears in the column data.
- Antares
- 0.7.1
- Installed from Ubuntu Software Store --
- OS name: Ubuntu
- OS version 20.04 LTS
- DB name MySQL
- DB version 5.7.37 Community Server
Additional context The first time I encountered this, having exported as CSV, I saw that the file was not loadable as a spreadsheet, so I went back and (without rerunning the query) chose Export as JSON. After choosing the download file name, Antares crashed without saving the file. I was not able to reproduce this.
