[teiid-issues] [JBoss JIRA] (TEIID-2984) MongoDB: Usage of function "mod()" in SQL query throws an exception
RH Bugzilla Integration (JIRA)
issues at jboss.org
Thu Nov 27 05:08:42 EST 2014
[ https://issues.jboss.org/browse/TEIID-2984?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13023489#comment-13023489 ]
RH Bugzilla Integration commented on TEIID-2984:
------------------------------------------------
Filip Elias <felias at redhat.com> changed the Status of [bug 1104758|https://bugzilla.redhat.com/show_bug.cgi?id=1104758] from ON_QA to VERIFIED
> MongoDB: Usage of function "mod()" in SQL query throws an exception
> -------------------------------------------------------------------
>
> Key: TEIID-2984
> URL: https://issues.jboss.org/browse/TEIID-2984
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.4.1
> Reporter: Filip Elias
> Assignee: Ramesh Reddy
> Fix For: 8.8, 8.7.1
>
> Attachments: server.log
>
>
> Exception[1] is thrown when function modulo(mod) is used in SQL query.
> Sample query:
> SELECT LongNum, 11, MOD(LongNum, 11) FROM BQT1.SmallA ORDER BY LONGNUM
> Server log is in the attachment.
> [1] 16:36:59,645 ERROR [org.teiid.CONNECTOR] (Worker10_QueryProcessorQueue71) Connector worker process failed for atomic-request=hRCP8hHjrmZb.25.0.13: com.mongodb.CommandFailureException: { "serverUsed" : "localhost/127.0.0.1:27017" , "errmsg" : "exception: disallowed field type Array in object expression (at 'mod')" , "code" : 15992 , "ok" : 0.0}
> at com.mongodb.CommandResult.getException(CommandResult.java:71)
> at com.mongodb.CommandResult.throwOnError(CommandResult.java:110)
> at com.mongodb.DBCollection.aggregate(DBCollection.java:1308)
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
More information about the teiid-issues
mailing list