Revision 47788 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
94 94 
       "test"."Bool5",
95 95 
       "test"."Decimal",
96 96 
       "test"."Geometry",
97 
       EXISTS( SELECT "countries"."Long" FROM "countries" WHERE (("test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0)) LIMIT 1 ) AS "EXISTS62a964cd7bc24f409b97c03b9170408d"
97 
       EXISTS( SELECT "test"."Long" FROM "countries" WHERE (("test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0)) LIMIT 1 ) AS "EXISTS62a964cd7bc24f409b97c03b9170408d"
98 98 
FROM "test"
99 
WHERE EXISTS( SELECT "countries"."Long"
99 
WHERE EXISTS( SELECT "test"."Long"
100 100 
                    FROM "countries"
101 101 
                    WHERE (("test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0))
102 102 
                    LIMIT 1 )

Also available in: Unified diff