Revision 44769 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.h2/src/test/resources/org/gvsig/fmap/dal/store/h2/resultSetForSetProvider.sql

View differences:

resultSetForSetProvider.sql
24 24 
    "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal",
25 25 
    NVL2("Geometry",ST_AsBinary("Geometry"),NULL),
26 26 
    NVL2(COALESCE((
27 
      SELECT 1
27 
      SELECT "ISO_A2"
28 28 
      FROM "countries"
29 29 
      WHERE (("TEST"."STRING" = "countries"."CONTINENT") AND
30 30 
        ("countries"."LASTCENSUS" < 0)) LIMIT 1)),TRUE,FALSE)
31 31 
    AS "EXISTS62a964cd7bc24f409b97c03b9170408d"
32 32 
  FROM "PUBLIC"."test"
33 33 
  WHERE NVL2(COALESCE((
34 
    SELECT 1
34 
    SELECT "ISO_A2"
35 35 
    FROM "countries"
36 36 
    WHERE (("TEST"."STRING" = "countries"."CONTINENT") AND
37 37 
      ("countries"."LASTCENSUS" < 0)) LIMIT 1)),TRUE,FALSE);

Also available in: Unified diff