Revision 47788 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 | ||
|---|---|---|
| 93 | 93 |
"PUBLIC"."test"."Bool5", |
| 94 | 94 |
"PUBLIC"."test"."Decimal", |
| 95 | 95 |
NVL2("PUBLIC"."test"."Geometry",ST_AsBinary("PUBLIC"."test"."Geometry"),NULL),
|
| 96 |
NVL2(COALESCE(( SELECT "PUBLIC"."countries"."Long" FROM "PUBLIC"."countries" WHERE (("PUBLIC"."test"."STRING" = "PUBLIC"."countries"."CONTINENT") AND ("PUBLIC"."countries"."LASTCENSUS" < 0)) LIMIT 1 )),TRUE,FALSE) AS "EXISTS62a964cd7bc24f409b97c03b9170408d"
|
|
| 96 |
NVL2(COALESCE(( SELECT "PUBLIC"."test"."Long" FROM "PUBLIC"."countries" WHERE (("PUBLIC"."test"."STRING" = "PUBLIC"."countries"."CONTINENT") AND ("PUBLIC"."countries"."LASTCENSUS" < 0)) LIMIT 1 )),TRUE,FALSE) AS "EXISTS62a964cd7bc24f409b97c03b9170408d"
|
|
| 97 | 97 |
FROM "PUBLIC"."test" |
| 98 |
WHERE NVL2(COALESCE(( SELECT "PUBLIC"."countries"."Long"
|
|
| 98 |
WHERE NVL2(COALESCE(( SELECT "PUBLIC"."test"."Long"
|
|
| 99 | 99 |
FROM "PUBLIC"."countries" |
| 100 | 100 |
WHERE (("PUBLIC"."test"."STRING" = "PUBLIC"."countries"."CONTINENT") AND ("PUBLIC"."countries"."LASTCENSUS" < 0))
|
| 101 | 101 |
LIMIT 1 )),TRUE,FALSE) |
Also available in: Unified diff