ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Guido García Bernardo <ggb...@tid.es>
Subject nested iterate over 2 different properties
Date Mon, 08 May 2006 09:33:21 GMT
Hello,

I am using ibatis 2.1.7, and I have the following sql statement:

<statement ...>
    <iterate property="tabla" conjunction="UNION">
    SELECT      
        <iterate property="agrupaciones" conjunction=",">
            TABLA.$agrupaciones[]$
        </iterate>
    FROM $tabla[]$ TABLA
    WHERE
        TABLA.A IN ('A','B','C','D','W','G')
    </iterate>
</statement>

where:
    $tabla[]$ = { "PENDIENTES", "ANULADAS" }
    $agrupaciones[]$ = { "AREA" }

but the generated sentence is:

    SELECT
        TABLA.AREA
    FROM PENDIENTES TABLA
    WHERE
        TABLA.A IN ('A','B','C','D','W','G')   
    UNION
    SELECT
    FROM ANULADAS TABLA WHERE
        TABLA.A IN ('A','B','C','D','W','G')

instead of:

    SELECT
        TABLA.AREA
    FROM PENDIENTES TABLA
    WHERE
        TABLA.A IN ('A','B','C','D','W','G')    
    UNION   
    SELECT
        TABLA.AREA
    FROM ANULADAS TABLA
    WHERE
        TABLA.A IN ('A','B','C','D','W','G')   

It seems not to be using the correct index for the property 
"agrupaciones" in the second iteration of the property "tabla"... I 
think this is a bug (maybe related to 
http://issues.apache.org/jira/browse/IBATIS-281)
Is there any idea or workaround to solve it?

Thank you very much,
Guido García Bernardo

Mime
View raw message