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)