Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-2267

Query constraints on node name and local name are swapped

    XMLWordPrintable

Details

    Description

      When querying ModeShape, thru Teiid, the returned data appears to have the column data swapped between columns.

      Example:

      Query:

      select jcr_name, mode_localName from nt_base where mode_localName LIKE '%zip%'
      
      jcr_name         mode_locaName
      --------         -------------
      zip              zip
      zip:content      content
      zip:file         file
      

      Query:

      select jcr_name, mode_localName from nt_base where jcr_name LIKE '%zip%'
      
      jcr_name         mode_locaName
      --------         -------------
      zip              zip
      

      And we have someone else that just posted a similar issue with this behavior.

      In discussion with Teiid engineers, Teiid uses column position, not by name, for obtaining the column data. So we think there is an issue in the jdbc driver where its getting the position order mixed up on the result set metadata.

      Attachments

        Issue Links

          Activity

            People

              hchiorean Horia Chiorean (Inactive)
              van.halbert Van Halbert (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: