Revision 46111 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.h2spatial/org.gvsig.h2spatial.h2gis132/org.gvsig.h2spatial.h2gis132.provider/src/test/resources/org/gvsig/fmap/dal/store/h2/resultSetForSetProvider.sql
resultSetForSetProvider.sql | ||
---|---|---|
106 | 106 |
("ID" * 2) AS "Compu1", |
107 | 107 |
SUM(("Long" + 300)) AS "Compu2", |
108 | 108 |
SUM(((20 + "Byte") + ("ID" * 2))) AS "Extra2", |
109 |
(("Long" + 10) + (("ID" * 2))) AS "Extra1"
|
|
110 |
FROM "PUBLIC"."test" GROUP BY "test"."Long", (("Long" + 10) + (("ID" * 2))), (("ID" * 2))
|
|
109 |
(("Long" + 10) + ("ID" * 2)) AS "Extra1"
|
|
110 |
FROM "PUBLIC"."test" GROUP BY "test"."Long", (("Long" + 10) + (("ID" * 2))), ("ID" * 2)
|
|
111 | 111 |
ORDER BY "test"."Long" ASC NULLS LAST, "Extra1" ASC NULLS LAST, "Compu1" ASC NULLS LAST, "ID" ASC NULLS LAST; |
Also available in: Unified diff