[teiid-issues] [JBoss JIRA] Created: (TEIID-1177) Allow for implicit temp table definition with just a query, omitting the columns

Fri Jul 30 16:28:49 EDT 2010

Allow for implicit temp table definition with just a query, omitting the columns 
---------------------------------------------------------------------------------

                 Key: TEIID-1177
                 URL: https://jira.jboss.org/browse/TEIID-1177
             Project: Teiid
          Issue Type: Feature Request
          Components: Query Engine
    Affects Versions: 7.1
            Reporter: Steve Hawkins
            Assignee: Steve Hawkins
            Priority: Optional
             Fix For: 7.1


currently you must use target columns to define a temp table with a query expression:
insert into #temp (x, y,z) select x, y, z from t

but the following should be allowed as well:
insert into #temp select x, y, z from t

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