Revision 47580 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.sqlite/org.gvsig.sqlite.provider/src/test/resources/org/gvsig/sqlite/dal/resultSetForSetProvider.sql

View differences:

resultSetForSetProvider.sql
67 67 
       "test"."Bool5",
68 68 
       "test"."Decimal",
69 69 
       "test"."Geometry",
70 
       NVL2(COALESCE(( SELECT "countries"."ISO_A2" FROM "countries" WHERE (("test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0)) LIMIT 1 )),TRUE,FALSE) AS "EXISTS62a964cd7bc24f409b97c03b9170408d"
71 
FROM "test"
72 
WHERE NVL2(COALESCE(( SELECT "countries"."ISO_A2"
73 
                    FROM "countries"
74 
                    WHERE (("test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0))
75 
                    LIMIT 1 )),TRUE,FALSE)
70 
        EXISTS( SELECT "countries"."ISO2"
71 
            FROM "countries"
72 
            WHERE (("test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0)) LIMIT 1 ) AS "EXISTS62a964cd7bc24f409b97c03b9170408d"
73 
FROM "test"
74 
WHERE EXISTS( SELECT "countries"."ISO2"
75 
	FROM "countries"
76 
	WHERE (("test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0)) LIMIT 1 )
76 77 
ORDER BY "test"."ID" ASC
77 78 
-- end testSubselect
78 79 

  		




  ......




  93
  94
  
    
       "test"."Bool5",


  		




  94
  95
  
    
       "test"."Decimal",


  		




  95
  96
  
    
       "test"."Geometry",


  		




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


  		




  
  97
  
    
       EXISTS( SELECT "test"."Long" FROM "countries" WHERE (("test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0)) LIMIT 1 ) AS "EXISTS62a964cd7bc24f409b97c03b9170408d"


  		




  97
  98
  
    
FROM "test"


  		




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


  		




  
  99
  
    
WHERE EXISTS( SELECT "test"."Long"


  		




  99
  100
  
    
                    FROM "countries"


  		




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


  		




  101
  
  
    
                    LIMIT 1 )),TRUE,FALSE)


  		




  
  102
  
    
                    LIMIT 1 )


  		




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


  		




  103
  104
  
    
-- end testSubselect2


  		




  104
  105
  
    

  		




  ......




  120
  121
  
    
       NULL AS "Decimal",


  		




  121
  122
  
    
       NULL AS "Geometry"


  		




  122
  123
  
    
FROM "test"


  		




  123
  
  
    
WHERE NVL2(COALESCE(( SELECT "countries"."ISO_A2"


  		




  
  124
  
    
WHERE EXISTS( SELECT "countries"."ISO2"


  		




  124
  125
  
    
                    FROM "countries"


  		




  125
  126
  
    
                    WHERE (("test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0))


  		




  126
  
  
    
                    LIMIT 1 )),TRUE,FALSE)


  		




  
  127
  
    
                    LIMIT 1 )


  		




  127
  128
  
    
GROUP BY "test"."Long"


  		




  128
  129
  
    
ORDER BY "test"."Long" ASC NULLS LAST


  		




  129
  130
  
    
-- end testGroupAndSubselect


  		












Also available in:  Unified diff