[
https://issues.jboss.org/browse/TEIID-2848?page=com.atlassian.jira.plugin...
]
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)