Revision 44750 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
16 16 
    NULL AS "Bool4", NULL AS "Float", NULL AS "Bool5", NULL AS "Decimal",
17 17 
    NULL AS "Geometry"
18 18 
  FROM "PUBLIC"."test"
19 
  GROUP BY "Long";
19 
  GROUP BY "Long";
20 

  		




  
  21
  
    
-- Subselect


  		




  
  22
  
    
SELECT 


  		




  
  23
  
    
    "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", "Bool2", 


  		




  
  24
  
    
    "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal", 


  		




  
  25
  
    
    NVL2("Geometry",ST_AsBinary("Geometry"),NULL), 


  		




  
  26
  
    
    NVL2(COALESCE((


  		




  
  27
  
    
      SELECT 1 


  		




  
  28
  
    
      FROM "countries" 


  		




  
  29
  
    
      WHERE (("TEST"."STRING" = "countries"."CONTINENT") AND 


  		




  
  30
  
    
        ("countries"."LASTCENSUS" < 0)) LIMIT 1)),TRUE,FALSE) 


  		




  
  31
  
    
    AS "EXISTS62a964cd7bc24f409b97c03b9170408d" 


  		




  
  32
  
    
  FROM "PUBLIC"."test" 


  		




  
  33
  
    
  WHERE NVL2(COALESCE((


  		




  
  34
  
    
    SELECT 1 


  		




  
  35
  
    
    FROM "countries" 


  		




  
  36
  
    
    WHERE (("TEST"."STRING" = "countries"."CONTINENT") AND 


  		




  
  37
  
    
      ("countries"."LASTCENSUS" < 0)) LIMIT 1)),TRUE,FALSE);


  		




  
  38
  
    

  		












Also available in:  Unified diff