[teiid-issues] [JBoss JIRA] (TEIID-5216) JBOSS - Teiid 9.2.1 unable to return DateTimeOffset ODatatype values

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-5216:
-------------------------------------

I believe unless it is a containment I did all as separate tables if the metadata for them defined in separate entity/complex types, that way I could handle querying for collection and single entity similarly with expand. But what I see is missing is

1) I stopped at creating single navigation per entity 
2) The join columns (psedeo) columns were not correctly have been used do a expand.

So far with the cursory look, I got that far, I will look more today.

> JBOSS - Teiid 9.2.1 unable to return DateTimeOffset ODatatype values
> --------------------------------------------------------------------
>
>                 Key: TEIID-5216
>                 URL: https://issues.jboss.org/browse/TEIID-5216
>             Project: Teiid
>          Issue Type: Bug
>          Components: OData
>    Affects Versions: 9.2.1
>         Environment: All
>            Reporter: Pushkar Kamra
>            Assignee: Steven Hawkins
>             Fix For: 10.1
>
>         Attachments: screenshot-1.png
>
>
> During the time of requesting ODatatype - DateTimeOffset from the from the following service - http://services.odata.org/V4/Northwind/Northwind.svc/
> Query - Select * from Employees.
> Using the above query it is unable to return DateTimeOffset  values for it and returns the 
> following error - 
> java.lang.IllegalArgumentException: No enum constant org.apache.olingo.commons.api.edm.EdmPrimitiveTypeKind.TimeOffset
>         at java.lang.Enum.valueOf(Enum.java:238)
>         at org.apache.olingo.commons.api.edm.EdmPrimitiveTypeKind.valueOf(EdmPrimitiveTypeKind.java:24)
>         at org.teiid.olingo.common.ODataTypeManager.parseLiteral(ODataTypeManager.java:332)
>         at org.teiid.olingo.common.ODataTypeManager.convertToTeiidRuntimeType(ODataTypeManager.java:184)
>         at org.teiid.translator.odata4.BaseQueryExecution.buildRow(BaseQueryExecution.java:244)
>         at org.teiid.translator.odata4.ODataQueryExecution.next(ODataQueryExecution.java:122)
>         at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:435)
>         at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:238)
>         at sun.reflect.GeneratedMethodAccessor480.invoke(Unknown Source)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:498)
>         at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:220)
>         at com.sun.proxy.$Proxy398.more(Unknown Source)
>         at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309)
>         at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
>         at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
>         at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>         at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
>         at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
>         at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> From the initial level analysis and observation is has been observed teiid class - ODataTypeManager in that parselitreals method where ODatatype.Substring(4) is done which is causing the issue which is changing DateTimeOffset to TimeOffset and when it tries to find the Enum constant from the EdmPrimitiveTypeKind list it is unable find the changed name and this seems to be causing the issue in accessing the DateTimeOffset type datas from the containing tables. 



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)