View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0002440 | SymmetricDS | Bug | public | 2015-11-05 20:34 | 2019-04-23 20:28 |
Reporter | rotten | Assigned To | |||
Priority | normal | ||||
Status | new | Resolution | open | ||
Product Version | 3.7.26 | ||||
Summary | 0002440: dbexport --sql doesn't work | ||||
Description | When I use dbexport --sql "select col_a, col_b from mytable" --format CSV, to dump a subset of the columns in my table, dbexport writes the names of all of the columns as the header, not just the ones from my select statement. Then it picks columns off of the table in the order they are in the table, ignoring my select statement except to truncate the list at the number of columns I had in my select statement. It appears to be completely ignoring my --sql statement except for the number of columns that it was returning. ** I've only tested dbexport --sql against mysql 5.6 at this time. ** | ||||
Additional Information | My work around is to use the mysql command line tool to generate the csv. | ||||
Tags | dbimport/dbexport | ||||