[teiid-issues] [JBoss JIRA] (TEIID-5359) Resultset metadata defaults to case insensitive

[Andrej Šmigala (Jira)]

    [ https://issues.jboss.org/browse/TEIID-5359?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13673590#comment-13673590 ] 

Andrej Šmigala commented on TEIID-5359:
---------------------------------------

[~shawkins] do I understand correctly that this should affect the result set metadata for string columns?
I have a view with string column and no options on that column, then issuing {code:sql}SELECT col_default FROM View.c1{code} and running
{code:java}resultSet.getMetaData().isCaseSensitive(1){code}
returns true even on DV 6.4.5



> Resultset metadata defaults to case insensitive
> -----------------------------------------------
>
>                 Key: TEIID-5359
>                 URL: https://issues.jboss.org/browse/TEIID-5359
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 11.0, 8.12.17.6_4
>
>
> MetaDataProcessor.getDefaultColumn uses case_sensitive false - which is not correct as Teiid treats all strings as case sensitive by default.  Having the default as true for non-character columns is also not harmful.



--
This message was sent by Atlassian Jira
(v7.12.1#712002)