You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Larry Meadors (JIRA)" <ib...@incubator.apache.org> on 2005/02/02 14:11:17 UTC
[jira] Closed: (IBATIS-64) Recursive inclusions don't expand
[ http://issues.apache.org/jira/browse/IBATIS-64?page=history ]
Larry Meadors closed IBATIS-64:
-------------------------------
Resolution: Duplicate
Duplicate of issue 65: http://issues.apache.org/jira/browse/IBATIS-65
> Recursive inclusions don't expand
> ---------------------------------
>
> Key: IBATIS-64
> URL: http://issues.apache.org/jira/browse/IBATIS-64
> Project: iBatis for Java
> Type: Bug
> Components: SQL Maps
> Versions: 2.0.9
> Reporter: Rohan Lenard
>
> Given the documentation doesn't mention this it is hard to know what is correct.
> I have an SQL Map like this
> <?xml version="1.0" encoding="UTF-8" ?>
> <!DOCTYPE sqlMap
> PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
> "http://www.ibatis.com/dtd/sql-map-2.dtd">
> <sqlMap>
> <select id="getFrequencyTableData" parameterClass="java.util.Map" resultMap="frequency-table-result">
> SELECT sum(a) as a FROM tablea
> <dynamic prepend="WHERE">
> $consolidationLevelClause$
> AND
> (
> ( consolidation = #consolidationValues__0#
> <isPropertyAvailable property="startValues__0"> AND start < #startValues__0#
> </isPropertyAvailable>
> )
> <isPropertyAvailable property="consolidationValues__1">
> OR
> ( consolidation = #consolidationValues__1# AND start >= #startValues__1#
> <isPropertyAvailable property="startValues__2">
> AND start < #startValues__2#
> </isPropertyAvailable>
> )
> <isPropertyAvailable property="consolidationValues__2">
> OR ( consolidation = #consolidationValues__2# AND start >= #startValues__3#
> <isPropertyAvailable property="startValues__4">
> AND start
> < #startValues__4#
> </isPropertyAvailable> )
> </isPropertyAvailable>
> <!-- This should never happen - but it's a good test -->
> <isPropertyAvailable property="consolidationValues__3">
> OR ( consolidation = #consolidationValues__3# AND start >= #startValues__5#
> <isPropertyAvailable property="startValues__6">
> AND start
> < #startValues__6#
> </isPropertyAvailable> )
> </isPropertyAvailable>
> </isPropertyAvailable>
> )
> </isNotNull>
> <!-- select endpoints -->
> <isNotNull property="haveEndpoints">
> AND (
> <isNotNull property="ep1_to_ep2">
> ( <!-- handle EP1->EP2 direction -->
> direction = 'EP1->EP2' AND epPairDefnId IN
> <iterate property="ep1_to_ep2" open="(" close=")" conjunction=", ">
> #ep1_to_ep2[]#
> </iterate>
> )
> <isNotNull property="ep2_to_ep1">
> OR
> </isNotNull>
> </isNotNull>
> <isNotNull property="ep2_to_ep1">
> ( <!-- handle EP2->EP1 direction -->
> direction = 'EP2->EP1' AND epPairDefnId IN
> <iterate property="ep2_to_ep1" open="(" close=")" conjunction=", ">
> #ep2_to_ep1[]#
> </iterate>
> )
> </isNotNull>
> )
> </isNotNull>
> <isNotNull property="timeRestrictFrom">
> AND ( $timeRestrictStartField$ >= #timeRestrictStartValue# )
> </isNotNull>
> <isNotNull property="timeRestrictTo">
> AND ( $timeRestrictEndField$ <= #timeRestrictEndValue# )
> </isNotNull>
> <isNotNull property="timeRestrictBetween">
> AND ( $timeRestrictStartField$ >= #timeRestrictStartValue#
> AND $timeRestrictEndField$ <= #timeRestrictEndValue# )
> </isNotNull>
> <isNotNull property="timeRestrictOnly">
> AND ( $timeRestrictStartField$ = #timeRestrictStartValue#
> AND $timeRestrictEndField$ = #timeRestrictStartValue# )
> </isNotNull>
> <isNotNull property="timePeriodClause">
> AND $timePeriodClause$
> </isNotNull>
> </dynamic>
> GROUP BY
> <isNotNull property="timeChunkClause">
> begin,
> </isNotNull>
> <!-- Note: upperlimit is "strictly" required - but not by MYSQL - for HSQLDB and probably other DBs -->
> lowerlimit, upperlimit
> </select>
> </sqlMap>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira