Subject: | Bug Report |
Date: | Tue, 18 Aug 2015 23:05:47 +0000 |
To: | "bug-DBD-CSV [...] rt.cpan.org" <bug-DBD-CSV [...] rt.cpan.org> |
From: | "Adkins, Blake" <blake.adkins [...] intel.com> |
Submitting a bug report with using -SELECT and when columns of the .csv file are reserved words in SQL. I have a case where a column is named "DESC" in the database, not SQL, it's being exported to a .csv file from. However, if I try to select the column in the SQL query using DBI, like SELECT "PT_ID,'DESC'" it doesn't complain but it returns something like
PT_ID,DESC
PT_1,DESC
PT_2,DESC
Instead of
PT_ID,DESC
PT_1,FOO
PT_2,BAR.
Let me know if I can provide more information.
Thanks,
Blake Adkins