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

Query constraints on node name and local name are swapped

    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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  hchiorean Horia Chiorean
                  Reporter:
                  van.halbert Van Halbert
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: