Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5672

Support nanosecond precision for MySQL version > 5.6

XMLWordPrintable

      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.

            rhn-engineering-shawkins Steven Hawkins
            cjohn001 Christoph John (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: