View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001170 | SymmetricDS | Bug | public | 2013-04-10 14:11 | 2014-02-03 01:53 |
Reporter | abrougher | Assigned To | chenson | ||
Priority | normal | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.3.6 | ||||
Target Version | 3.3.7 | Fixed in Version | 3.3.7 | ||
Summary | 0001170: postgres - Inserts fail on reverse reload events when a table contains duplicate rows. | ||||
Description | I have a table w/ out a PK. DDL below. When the data loader is acting an a reverse initial load I was getting the following error. [server-000] - DataLoaderService - Failed to load batch orgid2-365 because: ERROR: more than one row returned by a subquery used as an expression. -- Insert that was failing. insert into "system_classifications"("class_name") (select ? where (select 1 from "system_classifications" where "class_name" = ?) is null); -- The following returns two rows since there is a duplicate in my table. This causes the insert to fail and freeze the reload. select 1 from "system_classifications" where "class_name" = ? -- Table: system_classifications -- DROP TABLE system_classifications; CREATE TABLE system_classifications ( class_name text NOT NULL DEFAULT ''::text ) WITH ( OIDS=FALSE ); ALTER TABLE system_classifications OWNER TO postgres; | ||||
Tags | No tags attached. | ||||
SymmetricDS: master dd4706b2 2013-04-11 08:14:49 Details Diff |
0001170: postgres - Inserts fail on reverse reload events when a table contains duplicate rows. |
Affected Issues 0001170 |
|
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDmlStatement.java | Diff File | ||
SymmetricDS: master dfab28a3 2013-04-11 09:42:41 Details Diff |
0001170: postgres - Inserts fail on reverse reload events when a table contains duplicate rows. |
Affected Issues 0001170 |
|
mod - symmetric-client/src/test/java/org/jumpmind/symmetric/DbExportImportTest.java | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2013-04-10 14:11 | abrougher | New Issue | |
2013-04-10 14:11 | abrougher | Status | new => assigned |
2013-04-10 14:11 | abrougher | Assigned To | => chenson |
2013-04-11 12:14 | chenson | Summary | Inserts fail on reverse reload events when a table contains duplicate rows. => postgres - Inserts fail on reverse reload events when a table contains duplicate rows. |
2013-04-11 12:14 | chenson | Status | assigned => resolved |
2013-04-11 12:14 | chenson | Fixed in Version | => 3.4.0 |
2013-04-11 12:14 | chenson | Resolution | open => fixed |
2013-04-11 13:58 | chenson | Fixed in Version | 3.4.0 => 3.3.7 |
2013-04-26 17:03 | chenson | Status | resolved => closed |
2014-02-03 01:53 | Changeset attached | => SymmetricDS trunk r7061 | |
2014-02-03 01:53 | Changeset attached | => SymmetricDS trunk r7062 | |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master dfab28a3 |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master dd4706b2 |