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.