Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1177

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

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Optional Optional
    • 7.1
    • 7.1
    • Query Engine
    • None

      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

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: