Revision 43647 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/ResultSetForSetProviderOperation.java

View differences:

ResultSetForSetProviderOperation.java
99 99
        for(FeatureAttributeDescriptor attr : storeType.getPrimaryKey() ) {
100 100
            primaryKeys.add(attr.getName());
101 101
        }
102
        for(String attrName : primaryKeys ) {
103
            // Ordenamos siempre por las claves primarias para garantizar 
104
            // un orden predecible. Ademas se precisa indicar un orden para
105
            // usar OFFSET.
106
            sqlbuilder.select().order_by().column(sqlbuilder.identifier(attrName)).ascending();
102
        if( offset>0 ) {
103
            for(String attrName : primaryKeys ) {
104
                // Se precisa indicar un orden para usar OFFSET.
105
                sqlbuilder.select().order_by().column(sqlbuilder.identifier(attrName)).ascending();
106
            }
107 107
        }
108 108
        String[] constantsAttributeNames = null;
109 109
        if(query !=null && query.hasConstantsAttributeNames() ) {

Also available in: Unified diff