[jboss-jira] [JBoss JIRA] Commented: (JBAS-4462) mod() function not supported in SQL server 2005

Wed Jun 6 08:51:08 EDT 2007

    [ 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