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

Error with pg arrays

    XMLWordPrintable

Details

    • DV Sprint 56
    • 1

    Description

      When I try the following query using customer-dv deployment against postgresql

      https://rdbms-springboot-dv-demo.apps.cluster-london-966d.london-966d.open.redhat.com/odata/accounts/customer(10)?$format=JSON&$expand=address_customer_fk

      I get the following error:
      {"error":{"code":"TEIID30504","message":"TEIID30504 sampledb: TEIID31176 Could not convert source column v_0.c_1 AS c_3 to the expected runtime type object[][]"}}

      This occurs with any pg array that is created with an expression:

      select (col, col2)..
      array_agg, etc.

      Attachments

        Issue Links

          Activity

            Public project attachment banner

              context keys: [headless, issue, helper, isAsynchronousRequest, project, action, user]
              current Project key: TEIID

              People

                rhn-engineering-shawkins Steven Hawkins
                rhn-engineering-shawkins Steven Hawkins
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Time Tracking

                    Estimated:
                    Original Estimate - 5 hours
                    5h
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 5 hours
                    5h