Revision 44361 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.jdbc/src/main/java/org/gvsig/fmap/dal/store/jdbc2/spi/operations/CalculateEnvelopeOfColumnOperation.java

View differences:

CalculateEnvelopeOfColumnOperation.java
76 76 
        ExpressionBuilder expbuilder = sqlbuilder.expression();
77 77
78 78 
        sqlbuilder.select().column().value(
79 
            expbuilder.ifnull(
80 
                expbuilder.column(columnName),
81 
                expbuilder.constant(null),
79 
//            expbuilder.ifnull(
80 
//                expbuilder.column(columnName),
81 
//                expbuilder.constant(null),
82 82 
                expbuilder.as_geometry(
83 83 
                    expbuilder.ST_ExtentAggregate(
84 84 
                            expbuilder.column(columnName)
85 85 
                    )
86 86 
                )
87 
            )
87 
//            )
88 88 
        );
89 
        sqlbuilder.select().group_by(expbuilder.column(columnName));
89 
//        sqlbuilder.select().group_by(expbuilder.column(columnName));
90 90 
        sqlbuilder.select().from().table()
91 91 
                .database(this.table.getDatabase())
92 92 
                .schema(this.table.getSchema())
......
121 121 
                );
122 122 
            }
123 123 
        }
124 
        sqlbuilder.select().where().and(
125 
            expbuilder.not_is_null(expbuilder.column(columnName))
126 
        );
127
124 128 
        sqlbuilder.setProperties(
125 129 
                Variable.class,
126 130 
                PROP_TABLE, table

Also available in: Unified diff