[teiid-issues] [JBoss JIRA] Commented: (TEIID-935) Teiid is making column names upper case, even when specified as lower

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-935:
--------------------------------------

How/when did you create the vdb?  The model has the Q13 view with an upper case column name.  In adminshell if you query just the transformation, the metadata will return a lowercase name.  This is probably a Designer issue.

> Teiid is making column names upper case, even when specified as lower
> ---------------------------------------------------------------------
>
>                 Key: TEIID-935
>                 URL: https://jira.jboss.org/jira/browse/TEIID-935
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.0
>         Environment: Fedora 12, OpenJDK Server VM (build 14.0-b16, mixed mode), Teiid build 1/19/2010
>            Reporter: Paul Nittel
>            Assignee: Steven Hawkins
>         Attachments: TextMetadataTesting.zip
>
>
> I've got a transformation that defines two columns like this:
> SELECT
>                 c_count, COUNT(*) AS custdist
> FROM
>                 (SELECT C_CUSTKEY, COUNT(O_ORDERKEY) AS c_count FROM TPCR.CUSTOMER LEFT OUTER JOIN TPCR.ORDERS ON C_CUSTKEY = O_CUSTKEY AND O_COMMENT NOT LIKE '%special%requests%' GROUP BY C_CUSTKEY) AS c_orders
> GROUP BY c_count
> In the past, when queried (SELECT * FROM ...), the columns were spelled c_count and custdist. Now they're spelled C_COUNT and custdist. Do we now upcase column names that are not specified as an alias (or do we only preserve case on aliases)?
> I noticed this in AdminShell, but see the Designer is also doing it, so I'm thinking it's the query engine, not the tool. (Steve H. agreed it should still be lower case when queried.)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira