Application: gvSIG desktop

    public void testSelectCountWhere2() {

        StringBuilder source = new StringBuilder();

        source.append("BEGIN");

        source.append("  tableName := 'countries';");

        source.append("  SELECT COUNT(*) FROM :tableName  ");

        source.append("    WHERE countries.LASTCENSUS > 0 ; ");

        source.append("END");

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source.toString());

        link(code);

        checkEquals("testSelectCountWhere", "BLOCK(LET('tableName', 'countries'), SELECT_COUNT($HOSTEXPRESSION(\"tableName\", 'IN'), (\"countries\".\"LASTCENSUS\" > 0)))", code.toString());

    }

    public void testSelectWhere3() {

        StringBuilder source = new StringBuilder();

        source.append("BEGIN");

        source.append("  tableName := 'countries';");

        source.append("  SELECT * FROM :tableName  ");

        source.append("    WHERE countries.LASTCENSUS > 0 ; ");

        source.append("END");

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source.toString());

        link(code);

        checkEquals("testSelectWhere3", "BLOCK(LET('tableName', 'countries'), SELECT(TUPLE(), $HOSTEXPRESSION(\"tableName\", 'IN'), (\"countries\".\"LASTCENSUS\" > 0), TUPLE(), TUPLE(), NULL))", code.toString());

    }