ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Olaf Bey" <olaf....@gmail.com>
Subject Re: nested iterate over 2 different properties
Date Mon, 08 May 2006 14:01:29 GMT
Hello Guido,

shouldn't it be #agrupaciones[]# instead of $agrupaciones[]# ?

Greetings,

Olaf

On 5/8/06, Guido García Bernardo <ggb275@tid.es> wrote:
>
> 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