[
http://jira.jboss.com/jira/browse/JBAS-4462?page=comments#action_12364338 ]
Rajesh Rajasekaran commented on JBAS-4462:
------------------------------------------
It was not tested with MS SQL Server 2000. We dont have a 2000 instance to test with.
But i see that MS SQL Server 2000 also had only the % operator. It never had the mod
function.
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/infmxsql.mspx
I have committed the fix to Branch_4_0 and trunk as well.
mod() function not supported in SQL server 2005
-----------------------------------------------
Key: JBAS-4462
URL:
http://jira.jboss.com/jira/browse/JBAS-4462
Project: JBoss Application Server
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: CMP service
Affects Versions: JBossAS-4.0.5.GA, JBossAS-5.0.0.Beta2, JBossAS-4.2.0.GA
Reporter: Alexey Loubyansky
Assigned To: Alexey Loubyansky
Fix For: JBossAS-4.0.5.SP1 , JBossAS-4.2.1.CR1, JBossAS-5.0.0.Beta3
Looks like the mod() function has been replaced by the % (Modulo) (SSIS) operator in MS
SQL Server 2005. It should be possible to customize it with a template.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira