Revision 46517 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
76 76 
ORDER BY "PUBLIC"."test"."ID" ASC
77 77 
-- end testSubselect
78 78 

  		




  
  79
  
    
-- begin testSubselect2


  		




  
  80
  
    
SELECT "PUBLIC"."test"."ID",


  		




  
  81
  
    
       "PUBLIC"."test"."Byte",


  		




  
  82
  
    
       "PUBLIC"."test"."Bool1",


  		




  
  83
  
    
       "PUBLIC"."test"."Long",


  		




  
  84
  
    
       "PUBLIC"."test"."Timestamp",


  		




  
  85
  
    
       "PUBLIC"."test"."Date",


  		




  
  86
  
    
       "PUBLIC"."test"."Time",


  		




  
  87
  
    
       "PUBLIC"."test"."Bool2",


  		




  
  88
  
    
       "PUBLIC"."test"."String",


  		




  
  89
  
    
       "PUBLIC"."test"."Bool3",


  		




  
  90
  
    
       "PUBLIC"."test"."Double",


  		




  
  91
  
    
       "PUBLIC"."test"."Bool4",


  		




  
  92
  
    
       "PUBLIC"."test"."Float",


  		




  
  93
  
    
       "PUBLIC"."test"."Bool5",


  		




  
  94
  
    
       "PUBLIC"."test"."Decimal",


  		




  
  95
  
    
       NVL2("PUBLIC"."test"."Geometry",ST_AsBinary("PUBLIC"."test"."Geometry"),NULL),


  		




  
  96
  
    
       NVL2(COALESCE(SELECT "PUBLIC"."test"."Long" FROM "countries" WHERE (("TEST"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0)) LIMIT 1),TRUE,FALSE) AS "EXISTS62a964cd7bc24f409b97c03b9170408d"


  		




  
  97
  
    
FROM "PUBLIC"."test"


  		




  
  98
  
    
WHERE NVL2(COALESCE(SELECT "PUBLIC"."test"."Long"


  		




  
  99
  
    
                    FROM "countries"


  		




  
  100
  
    
                    WHERE (("TEST"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0))


  		




  
  101
  
    
                    LIMIT 1),TRUE,FALSE)


  		




  
  102
  
    
ORDER BY "PUBLIC"."test"."ID" ASC


  		




  
  103
  
    
-- end testSubselect2


  		




  
  104
  
    

  		




  79
  105
  
    
-- begin testGroupAndSubselect


  		




  80
  106
  
    
SELECT MIN("PUBLIC"."test"."ID") AS "ID",


  		




  81
  107
  
    
       MAX("PUBLIC"."test"."Byte") AS "Byte",


  		












Also available in:  Unified diff