You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Rohan Lenard (JIRA)" <ib...@incubator.apache.org> on 2005/02/02 04:39:25 UTC
[jira] Created: (IBATIS-64) Recursive inclusions don't expand
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
[jira] Closed: (IBATIS-64) Recursive inclusions don't expand
Posted by "Larry Meadors (JIRA)" <ib...@incubator.apache.org>.
[ 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