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

[Paul Nittel (JIRA)]

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


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