Revision 45294 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 "test".Long";
20 20 

  		




  21
  21
  
    
-- Subselect


  		




  22
  22
  
    
SELECT 


  		




  ......




  49
  49
  
    
    FROM "countries" 


  		




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


  		




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


  		




  52
  
  
    
  GROUP BY "Long";


  		




  
  52
  
    
  GROUP BY "test"."Long";


  		




  53
  53
  
    

  		




  54
  54
  
    
-- Simple


  		




  55
  55
  
    
SELECT 


  		












Also available in:  Unified diff