Revision 46505 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.h2spatial/org.gvsig.h2spatial.h2gis132/org.gvsig.h2spatial.h2gis132.provider/src/test/java/org/gvsig/fmap/dal/store/h2/operations/usecases/arena2/TestArena2GroupByForeignValue.java
TestArena2GroupByForeignValue.java | ||
---|---|---|
84 | 84 |
query.getGroupByColumns().add("provincia"); |
85 | 85 |
query.getGroupByColumns().add("lesividad"); |
86 | 86 |
query.getAggregateFunctions().put("Acc", "SUM"); |
87 |
query.getOrder().add("provincia");
|
|
88 |
CountOperation count = operations.createCount(eFeatureType, table, null, query);
|
|
89 |
String sqlcount = count.getSQL();
|
|
90 |
System.out.println("###### SQL:" + sqlcount);
|
|
91 |
System.out.println("###### EXP:" + expectedSQLs.get(1));
|
|
87 |
query.getOrder().add("provincia");
|
|
88 |
CountOperation count = operations.createCount(eFeatureType, table, null, query);
|
|
89 |
String sqlcount = count.getSQL();
|
|
90 |
System.out.println("###### SQL:" + sqlcount);
|
|
91 |
System.out.println("###### EXP:" + expectedSQLs.get(1));
|
|
92 | 92 |
assertEquals("Count SQL", expectedSQLs.get(1), sqlcount); |
93 | 93 |
|
94 | 94 |
ResultSetForSetProviderOperation resultSetForSetProvider = operations.createResultSetForSetProvider( |
Also available in: Unified diff