Revision 46505 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/count.txt

View differences:

count.txt
5 5 

  		




  6
  6
  
    
-- begin SimpleGroup


  		




  7
  7
  
    
-- rem Count with group SQL


  		




  8
  
  
    
SELECT COUNT(*) 


  		




  9
  
  
    
  FROM ( 


  		




  10
  
  
    
    SELECT COUNT(*) 


  		




  11
  
  
    
    FROM "PUBLIC"."test" 


  		




  12
  
  
    
    GROUP BY "Long"


  		




  13
  
  
    
  ) as _subquery_alias_ 


  		




  
  8
  
    
SELECT COUNT(*) FROM ( SELECT MAX("PUBLIC"."test"."Byte") AS "Byte", MIN("PUBLIC"."test"."ID") AS "ID", SUM("PUBLIC"."test"."Double") AS "Double" FROM "PUBLIC"."test" GROUP BY "PUBLIC"."test"."Long") as _subquery_alias_ 


  		




  14
  9
  
    
-- end SimpleGroup


  		












Also available in:  Unified diff