Revision 44785 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
36 36 
    WHERE (("TEST"."STRING" = "countries"."CONTINENT") AND
37 37 
      ("countries"."LASTCENSUS" < 0)) LIMIT 1)),TRUE,FALSE);
38 38 

  		




  
  39
  
    
-- Group and Subselect


  		




  
  40
  
    
SELECT 


  		




  
  41
  
    
    MIN("ID") AS "ID", MAX("Byte") AS "Byte", NULL AS "Bool1", "Long", 


  		




  
  42
  
    
    NULL AS "Timestamp", NULL AS "Date", NULL AS "Time", NULL AS "Bool2", 


  		




  
  43
  
    
    NULL AS "String", NULL AS "Bool3", SUM("Double") AS "Double", 


  		




  
  44
  
    
    NULL AS "Bool4", NULL AS "Float", NULL AS "Bool5", NULL AS "Decimal", 


  		




  
  45
  
    
    NULL AS "Geometry" 


  		




  
  46
  
    
  FROM "PUBLIC"."test" 


  		




  
  47
  
    
  WHERE NVL2(COALESCE((


  		




  
  48
  
    
    SELECT "ISO_A2" 


  		




  
  49
  
    
    FROM "countries" 


  		




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


  		




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


  		




  
  52
  
    
  GROUP BY "Long";


  		




  
  53
  
    

  		












Also available in:  Unified diff