Revision 46105 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/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 "test"."Long" ORDER BY "ID" ASC;
19 
  GROUP BY "test"."Long" ORDER BY "test"."Long" ASC, "ID" ASC;
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 "test"."Long" ORDER BY "ID" ASC;


  		




  
  52
  
    
  GROUP BY "test"."Long" ORDER BY "test"."Long" ASC, "ID" ASC;


  		




  53
  53
  
    

  		




  54
  54
  
    
-- Simple


  		




  55
  55
  
    
SELECT 


  		




  ......




  107
  107
  
    
    SUM(("Long" + 300)) AS "Compu2", 


  		




  108
  108
  
    
    SUM(((20 + "Byte") + ("ID" * 2))) AS "Extra2", 


  		




  109
  109
  
    
    (("Long" + 10) + (("ID" * 2))) AS "Extra1" 


  		




  110
  
  
    
FROM "PUBLIC"."test" GROUP BY "test"."Long", (("Long" + 10) + (("ID" * 2))), (("ID" * 2)) ORDER BY "ID" ASC;


  		




  
  110
  
    
FROM "PUBLIC"."test" GROUP BY "test"."Long", (("Long" + 10) + (("ID" * 2))), (("ID" * 2)) 


  		




  
  111
  
    
ORDER BY "test"."Long" ASC, "Extra1" ASC, "Compu1" ASC, "ID" ASC;


  		












Also available in:  Unified diff