Revision 47787 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

View differences:

resultSetForSetProvider.sql
67 67 
       "PUBLIC"."test"."Bool5",
68 68 
       "PUBLIC"."test"."Decimal",
69 69 
       NVL2("PUBLIC"."test"."Geometry",ST_AsBinary("PUBLIC"."test"."Geometry"),NULL),
70 
       NVL2(COALESCE(( SELECT "countries"."ISO_A2" FROM "countries" WHERE (("PUBLIC"."test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0)) LIMIT 1 )),TRUE,FALSE) AS "EXISTS62a964cd7bc24f409b97c03b9170408d"
70 
       NVL2(COALESCE(( SELECT "PUBLIC"."countries"."ISO_A2" FROM "PUBLIC"."countries" WHERE (("PUBLIC"."test"."STRING" = "PUBLIC"."countries"."CONTINENT") AND ("PUBLIC"."countries"."LASTCENSUS" < 0)) LIMIT 1 )),TRUE,FALSE) AS "EXISTS62a964cd7bc24f409b97c03b9170408d"
71 71 
FROM "PUBLIC"."test"
72 
WHERE NVL2(COALESCE(( SELECT "countries"."ISO_A2"
73 
                    FROM "countries"
74 
                    WHERE (("PUBLIC"."test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0))
72 
WHERE NVL2(COALESCE(( SELECT "PUBLIC"."countries"."ISO_A2"
73 
                    FROM "PUBLIC"."countries"
74 
                    WHERE (("PUBLIC"."test"."STRING" = "PUBLIC"."countries"."CONTINENT") AND ("PUBLIC"."countries"."LASTCENSUS" < 0))
75 75 
                    LIMIT 1 )),TRUE,FALSE)
76 76 
ORDER BY "PUBLIC"."test"."ID" ASC
77 77 
-- end testSubselect
......
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"."test"."Long" FROM "countries" WHERE (("PUBLIC"."test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0)) LIMIT 1 )),TRUE,FALSE) AS "EXISTS62a964cd7bc24f409b97c03b9170408d"
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"
97 97 
FROM "PUBLIC"."test"
98 
WHERE NVL2(COALESCE(( SELECT "PUBLIC"."test"."Long"
99 
                    FROM "countries"
100 
                    WHERE (("PUBLIC"."test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0))
98 
WHERE NVL2(COALESCE(( SELECT "PUBLIC"."countries"."Long"
99 
                    FROM "PUBLIC"."countries"
100 
                    WHERE (("PUBLIC"."test"."STRING" = "PUBLIC"."countries"."CONTINENT") AND ("PUBLIC"."countries"."LASTCENSUS" < 0))
101 101 
                    LIMIT 1 )),TRUE,FALSE)
102 102 
ORDER BY "PUBLIC"."test"."ID" ASC
103 103 
-- end testSubselect2
......
120 120 
       NULL AS "Decimal",
121 121 
       NULL AS "Geometry"
122 122 
FROM "PUBLIC"."test"
123 
WHERE NVL2(COALESCE(( SELECT "countries"."ISO_A2"
124 
                    FROM "countries"
125 
                    WHERE (("PUBLIC"."test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0))
123 
WHERE NVL2(COALESCE(( SELECT "PUBLIC"."countries"."ISO_A2"
124 
                    FROM "PUBLIC"."countries"
125 
                    WHERE (("PUBLIC"."test"."STRING" = "PUBLIC"."countries"."CONTINENT") AND ("PUBLIC"."countries"."LASTCENSUS" < 0))
126 126 
                    LIMIT 1 )),TRUE,FALSE)
127 127 
GROUP BY "PUBLIC"."test"."Long"
128 128 
ORDER BY "PUBLIC"."test"."Long" ASC NULLS LAST

Also available in: Unified diff