View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000935 | SymmetricDS | Bug | public | 2012-11-29 22:22 | 2014-02-03 01:53 |
Reporter | cgledhill | Assigned To | chenson | ||
Priority | normal | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.1.10 | ||||
Target Version | 3.2.0 | Fixed in Version | 3.2.0 | ||
Summary | 0000935: dbexport null timestamp values from Oracle result in empty string ("") in CSV. | ||||
Description | I have noticed when the first field of an Oracle table is a timestamp and for records with null value, the result CSV output is the empty string ("") rather than just nothing. When importing this empty string into Postgres with dbimport, the insert fails. I ran sed on the CSV to remove the double quotes and then the import ran successfully. | ||||
Steps To Reproduce | Create an Oracle table with a single timestamp column and insert null into it and commit. run dbexport. You will see "" for the null timestamp record. Then, importing into a Postgres table results in an insert error. | ||||
Additional Information | Log output will be written to ../logs/ecnext38_pg.log [] - AbstractCommandLauncher - Option: name=format, value={CSV} [] - AbstractCommandLauncher - Option: name=properties, value={ecnext38_pg.prop} [] - AbstractCommandLauncher - Option: name=schema, value={ecadm} [] - AbstractCommandLauncher - Option: name=table, value={manta_subscriptions} [] - DatabaseWriter - Failed to process a insert event in batch -9999. Failed sql was: insert into "ecadm"."manta_subscriptions" ("activated", "billing_state", "cancelled", "created_time", "deactivated", "end_time", "initial_trans_id", "last_modified_by_subid", "last_trans_id", "modified_time", "sub_id", "type_id", "version", "sub_driver", "n_fails", "n_renewals", "n_resurrections", "end_time_orig", "id", "subscription_key", "cancelled_by_subid") values (cast(? as timestamp with time zone),?,cast(? as timestamp with time zone),cast(? as timestamp with time zone),cast(? as timestamp with time zone),cast(? as timestamp with time zone),?,?,?,cast(? as timestamp with time zone),?,?,?,?,?,?,?,cast(? as timestamp with time zone),?,?,?) Failed row data was: "",,,"2012-01-20 16:08:16.000000 -05:00",,,,,,,"4w1thxgxnp4odd","126847","1","pbl-add_pickaview",,,,,"f3adf2b8-1145-41f1-92f8-9b745e64864e","7983e0c6-6a3c-4277-8e51-324e613d0041", | ||||
Tags | No tags attached. | ||||
SymmetricDS: master 51cd76bf 2012-11-30 15:54:37 Details Diff |
0000935: dbexport null timestamp values from Oracle result in empty string ("") in CSV. |
Affected Issues 0000935 |
|
mod - symmetric-client/src/test/java/org/jumpmind/symmetric/DbExportImportTest.java | Diff File | ||
mod - symmetric-csv/src/main/java/org/jumpmind/symmetric/csv/CsvWriter.java | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2012-11-29 22:22 | cgledhill | New Issue | |
2012-11-30 20:54 | chenson | Fixed in Version | => 3.2.0 |
2012-11-30 20:54 | chenson | Target Version | => 3.2.0 |
2012-11-30 20:55 | chenson | Status | new => closed |
2012-11-30 20:55 | chenson | Assigned To | => chenson |
2012-11-30 20:55 | chenson | Resolution | open => fixed |
2014-02-03 01:53 | Changeset attached | => SymmetricDS trunk r6599 | |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master 51cd76bf |