Should this cause problems?

[Nathan Maves <Na...@Sun.COM>]

Here is the old sqlmap ...

<statement id="getPeriodsList" resultMap="periodsResult">
        SELECT to_char(day_date,'YYYY MM (MON)') as stringValue,
               min(trunc(day_date, 'MON')) as dateValue
        FROM financial_dates
        WHERE (trunc(Day_Date) &gt;= 
trunc(add_months(last_day(sysdate),- #value#))+1
          AND trunc(Day_Date) &lt;= trunc(add_months(sysdate,0)))
        GROUP BY to_char(day_date,'YYYY MM (MON)')
        ORDER BY 2
     </statement>

When run,  this above will hang.

DEBUG 12-06 10:41:22 {conn-100282} Connection  
(ConnectionLogProxy.java:42)
DEBUG 12-06 10:41:22 {pstm-100283} PreparedStatement:         SELECT 
to_char(day_date,'YYYY MM (MON)') as stringValue,                
min(trunc(day_date, 'MON')) as dateValue        FROM financial_dates    
      WHERE (trunc(Day_Date) >= trunc(add_months(last_day(sysdate),- 
?))+1          AND trunc(Day_Date) <= trunc(add_months(sysdate,0)))     
    GROUP BY to_char(day_date,'YYYY MM (MON)')         ORDER BY 2       
(PreparedStatementLogProxy.java:48)
DEBUG 12-06 10:41:22 {pstm-100283} Parameters: [12]  
(PreparedStatementLogProxy.java:49)
DEBUG 12-06 10:41:22 {pstm-100283} Types: [java.lang.String]  
(PreparedStatementLogProxy.java:50)

Nothing ever is returned.

We found that by removing the space after the minus sign "-#value#" 
everything worked perfectly.  This used to work for the last year and 
just recently start failing.

We are using Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

nathan