Project

General

Profile

Revision 1e60fc7c

ID1e60fc7cbc0840771728b02ea854b8642759b72d
Parent 19369d9b
Child 2b46bf5b

Added by Patrick Plitzner almost 3 years ago

#5448 Add "distinct" to SQL query as family table contains duplicate
rows

View differences:

app-import/src/main/java/eu/etaxonomy/cdm/io/redlist/gefaesspflanzen/RedListGefaesspflanzenImportClassification.java
70 70

  
71 71
    @Override
72 72
    protected String getRecordQuery(RedListGefaesspflanzenImportConfigurator config) {
73
        String result = "select e.*, f.FAMILIE "
73
        String result = "select distinct e.*, f.FAMILIE "
74 74
                + "from V_TAXATLAS_D20_EXPORT e, GATTUNG_FAMILIE f "
75 75
                + "where e.EPI1 = f.GATTUNG and e.NAMNR IN (@IDSET)";
76 76
        result = result.replace("@IDSET", IPartitionedIO.ID_LIST_TOKEN);

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)