Revision 45165 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
10 10 

  		




  11
  11
  
    
-- Simple Group by


  		




  12
  12
  
    
SELECT 


  		




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


  		




  
  13
  
    
    MIN("test"."ID") AS "ID", MAX("test"."Byte") AS "Byte", NULL AS "Bool1", "Long", 


  		




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


  		




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


  		




  
  15
  
    
    NULL AS "String", NULL AS "Bool3", SUM("test"."Double") AS "Double", 


  		




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


  		




  17
  17
  
    
    NULL AS "Geometry" 


  		




  18
  18
  
    
  FROM "PUBLIC"."test" 


  		




  ......




  38
  38
  
    

  		




  39
  39
  
    
-- Group and Subselect


  		




  40
  40
  
    
SELECT 


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  45
  45
  
    
    NULL AS "Geometry" 


  		




  46
  46
  
    
  FROM "PUBLIC"."test" 


  		












Also available in:  Unified diff