[JBoss JIRA] Updated: (TEIID-31) For SQL Server source, Operand data type numeric is invalid for modulo operator
by Ramesh Reddy (JIRA)
[ https://jira.jboss.org/jira/browse/TEIID-31?page=com.atlassian.jira.plugi... ]
Ramesh Reddy updated TEIID-31:
------------------------------
Component/s: Query Engine
Fix Version/s: 6.0.0
Affects Version/s: 6.x
> For SQL Server source, Operand data type numeric is invalid for modulo operator
> -------------------------------------------------------------------------------
>
> Key: TEIID-31
> URL: https://jira.jboss.org/jira/browse/TEIID-31
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 6.x
> Reporter: Paul Nittel
> Priority: Minor
> Fix For: 6.0.0
>
>
> Defect Tracker #15110: (This was origianally logged under 9792, but that alluded to disabling the MOD operator.)
> Using the model project set attached, I built a VDB for testing result set caching. The MOD function is not available to SQL server data sources. Here's the beginning of the stack trace (rest is attached).
> com.metamatrix.jdbc.MMSQLException: [MetaMatrix][SQLServer JDBC Driver][SQLServer]Operand data type numeric is invalid for modulo operator.
> at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:46)
> at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:33)
> at com.metamatrix.jdbc.MMStatement.setException(MMStatement.java:325)
> at com.metamatrix.jdbc.MMStatement.deliverMessage(MMStatement.java:437)
> at com.metamatrix.jdbc.MMStatement.access$000(MMStatement.java:54)
> at com.metamatrix.jdbc.MMStatement$1.deliverMessage(MMStatement.java:412)
> at com.metamatrix.common.comm.platform.socket.SocketClientWorker.deliverMessage(SocketClientWorker.java:38)
> at com.metamatrix.common.comm.platform.socket.SocketClientWorker.process(SocketClientWorker.java:34)
> at com.metamatrix.common.queue.QueueWorker.processIndirect(QueueWorker.java:95)
> at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:65)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 11 months