[teiid-issues] [JBoss JIRA] (TEIID-5672) When using DateTime datatype with millisecond fractions, i.e DateTime(3) the resulting urls for the records are invalid

[Christoph John (Jira)]

Christoph John created TEIID-5672:
-------------------------------------

             Summary: When using DateTime datatype with millisecond fractions, i.e DateTime(3) the resulting urls for the records are invalid
                 Key: TEIID-5672
                 URL: https://issues.jboss.org/browse/TEIID-5672
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 11.2.1
         Environment: Docker Container
            Reporter: Christoph John
            Assignee: Steven Hawkins


I am using a composite key based on a BIGINT and a DATETIME(3) value. The URLs which Teiid generates are invalid in this case. When using DATETIME(0) the links or ok. Example of generated record structure


{code:java}
<a:feed xmlns:a="http://www.w3.org/2005/Atom" xmlns:m="http://docs.oasis-open.org/odata/ns/metadata" xmlns:d="http://docs.oasis-open.org/odata/ns/data" m:context="https://morpheus.fritz.box/odata4/svc/my_nutri_diary/$metadata#Diary">
<a:id>
https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary
</a:id>
<a:entry>
<a:id>
https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(fkProfile=2,AddedDateTime=2019-03-03T17:53:12.676Z)
</a:id>
<a:title/>
<a:summary/>
<a:updated>2019-03-03T17:53:52Z</a:updated>
<a:author>
<a:name/>
</a:author>
<a:link rel="edit" href="https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(fkProfile=2,AddedDateTime=2019-03-03T17:53:12.676Z)"/>
<a:link rel="http://docs.oasis-open.org/odata/ns/related/fkDiaryToAccount" title="fkDiaryToAccount" href="https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(fkProfile=2,AddedDateTime=2019-03-03T17:53:12.676Z)/fkDiaryToAccount"/>
<a:link rel="http://docs.oasis-open.org/odata/ns/related/fkDiaryToFDBProducts" title="fkDiaryToFDBProducts" href="https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(fkProfile=2,AddedDateTime=2019-03-03T17:53:12.676Z)/fkDiaryToFDBProducts"/>
<a:link rel="http://docs.oasis-open.org/odata/ns/relatedlinks/fkDiaryToAccount" title="fkDiaryToAccount" href="https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(fkProfile=2,AddedDateTime=2019-03-03T17:53:12.676Z)/fkDiaryToAccount/$ref"/>
<a:link rel="http://docs.oasis-open.org/odata/ns/relatedlinks/fkDiaryToFDBProducts" title="fkDiaryToFDBProducts" href="https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(fkProfile=2,AddedDateTime=2019-03-03T17:53:12.676Z)/fkDiaryToFDBProducts/$ref"/>
<a:category scheme="http://docs.oasis-open.org/odata/ns/scheme" term="#svc.1.my_nutri_diary.Diary"/>
<a:content type="application/xml">
<m:properties>
<d:fkProfile m:type="Int64">2</d:fkProfile>
<d:AddedDateTime m:type="DateTimeOffset">2019-03-03T17:53:12.676Z</d:AddedDateTime>
<d:fkIdCode m:type="Int64">1772</d:fkIdCode>
<d:product_name>Mélange fruits secs</d:product_name>
<d:brands>Agrosourcing</d:brands>
<d:DatabaseID m:type="Int16">0</d:DatabaseID>
<d:MealNumber>5</d:MealNumber>
<d:AmountInG m:type="Double">100.0</d:AmountInG>
<d:Calories m:type="Double">0.0</d:Calories>
<d:ProteinsInG m:type="Double">-1.0</d:ProteinsInG>
<d:CarbohydratesInG m:type="Double">-1.0</d:CarbohydratesInG>
<d:SugarsInG m:type="Double">-1.0</d:SugarsInG>
<d:FatsInG m:type="Double">-1.0</d:FatsInG>
<d:SaturatedFatsInG m:type="Double">-1.0</d:SaturatedFatsInG>
<d:SaltsInG m:type="Double">-1.0</d:SaltsInG>
<d:Diarycol m:null="true"/>
</m:properties>
</a:content>
</a:entry>
{code}


When I navigate to 
https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(fkProfile=2,AddedDateTime=2019-03-03T17:53:12.676Z)

I get HTTP ERROR 404 page not found. Note: I replaced ":"with "%3A" in the url which was required with the date DateTime(0) keys if I remember correctly. But this did not help either.



--
This message was sent by Atlassian Jira
(v7.12.1#712002)