shouldn't it be #agrupaciones[]# instead of $agrupaciones[]# ?
Greetings,
Olaf
On 5/8/06, Guido García Bernardo <[EMAIL PROTECTED]> 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
