Details
-
Bug
-
Resolution: Done
-
Major
-
11.2.1
-
None
Description
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
<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>
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" (urlencode) in the url which was required to work with the DateTime(0) primary keys. But this did not help either.
