Revision 47787 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.h2spatial/org.gvsig.h2spatial.h2gis132/org.gvsig.h2spatial.h2gis132.provider/src/test/java/org/gvsig/fmap/dal/store/h2/operations/sql/TestResultSetForSetProvider.java

View differences:

TestResultSetForSetProvider.java
607 607 
                "test",
608 608 
                null
609 609 
        );
610 
        /*
611 
            FIXME: No esta claro que este test sea correcto.
612
613 
            En la subselect 'SELECT "Long" FROM countries...'
614 
            El campo "Long" no es de la tabla "countries" si no de la tabla "test";
615 
            pero como no se le indica la tabla pone la de la subselect, aunque si
616 
            no es ambigua la referencia a la columna y es de la tabla "test"
617 
            seria correcto "test"."Long" y no "countries"."Long".
618 
        */
610 619 
        StringBuilder filter = new StringBuilder();
611 620 
        filter.append("EXISTS(");
612 621 
        filter.append(" SELECT \"Long\" FROM countries");
622 
//        filter.append(" SELECT \"Long\", \"CONTINENT\" FROM countries");
613 623 
        filter.append("   WHERE ");
614 624 
        filter.append("     test.STRING = countries.CONTINENT AND ");
615 625 
        filter.append("     countries.LASTCENSUS < 0 ");

Also available in: Unified diff