[teiid-issues] [JBoss JIRA] (TEIID-2848) MongoDB: Provide Array support

[Ivan Chan (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13001065#comment-13001065 ] 

Ivan Chan commented on TEIID-2848:
----------------------------------

It seems like Teiid appends "IS NOT NULL" at the end of the SQL 

org.teiid.query.sql.lang.Query:SELECT MongoDB_Array.TeiidArray.CustomerID, MongoDB_Array.TeiidArray.FirstName, MongoDB_Array.TeiidArray.LastName, MongoDB_Array.TeiidArray.LanguageClass FROM MongoDB_Array.TeiidArray WHERE MongoDB_Array.TeiidArray.LanguageClass IS NOT NULL


org.teiid.jdbc.TeiidSQLException: TEIID30504 2051904800: TEIID18027 Any operations on array type column LanguageClass are not supported currently.
        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
        at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:667)
        at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:63)
        at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:515)
        at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:148)
        at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:511)
        at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:393)
        at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:327)
        at com.jaspersoft.commons.semantic.metaapi.impl.jdbc.BaseJdbcMetaDataFactoryImpl.getColumnsFromJDBCQuery(BaseJdbcMetaDataFactoryImpl.java:180)
        at com.jaspersoft.ji.semantic.action.DomainDesignerAction.runJDBCQuery(DomainDesignerAction.java:2111)

> MongoDB: Provide Array support 
> -------------------------------
>
>                 Key: TEIID-2848
>                 URL: https://issues.jboss.org/browse/TEIID-2848
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Misc. Connectors
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>              Labels: CR1
>             Fix For: 8.8, 8.7.1
>
>
> Provide array support for primitive data types in MongoDB  translator. The arrays are supported but as embedded documents in the one-2-many situation.



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)