View Issue Details

IDProjectCategoryView StatusLast Update
0005347SymmetricDSBugpublic2022-08-02 19:00
Reporterthaond Assigned Toemiller  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.13.3 
Target Version3.13.7Fixed in Version3.13.7 
Summary0005347: Incorrect implement in geometry type
DescriptionFollow is incorrect implement for geometry type of postgresql
File: org.jumpmind.db.platform.postgresql.PostgreSqlDmlStatement
Method: appendColumnEquals

@Override
    protected void appendColumnEquals(StringBuilder sql, Column column) {
        String typeToCast = getTypeToCast(column);
        if (typeToCast != null) {
            sql.append(quote).append(column.getName()).append(quote)
                    .append(" = cast(? as ").append(typeToCast).append(")");
        } else if (column.getJdbcTypeName() != null && (column.getJdbcTypeName().toUpperCase().contains(TypeMap.GEOMETRY) ||
                column.getJdbcTypeName().toUpperCase().contains(TypeMap.GEOGRAPHY))) {
            //sql.append(" = ST_GEOMFROMTEXT(?)");
             //GFD-SNMR2: set function for geometry type column
            sql.append(quote).append(column.getName()).append(quote).append(" = ST_GEOMFROMTEXT(?)");
        } else {
            super.appendColumnEquals(sql, column);
        }
    }
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.13 cd4625e1

2022-08-02 18:20:06

evan-miller-jumpmind

Details Diff
0005347: Fixed where clauses for PostGIS geometry type Affected Issues
0005347
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDmlStatement.java Diff File

SymmetricDS: 3.14 9b9b76ad

2022-08-02 18:26:39

evan-miller-jumpmind

Details Diff
0005347: Fixed where clauses for PostGIS geometry type Affected Issues
0005347
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDmlStatement.java Diff File

Issue History

Date Modified Username Field Change
2022-06-29 07:19 thaond New Issue
2022-08-02 18:18 emiller Assigned To => emiller
2022-08-02 18:18 emiller Status new => assigned
2022-08-02 18:26 emiller Status assigned => resolved
2022-08-02 18:26 emiller Resolution open => fixed
2022-08-02 18:26 emiller Fixed in Version => 3.13.7
2022-08-02 19:00 Changeset attached => SymmetricDS 3.13 cd4625e1
2022-08-02 19:00 Changeset attached => SymmetricDS 3.14 9b9b76ad