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

Odd resolving error with implicit temp groups

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.0, 8.12.5, 8.13.4
    • 7.7
    • Query Engine
    • None

    Description

      If a query expression is used to insert into an implicit temporary table and no columns are specified the resolver will complain when the query column names do not match those defined on the implicit table. For example:

      insert into #tmp_dates ... defines the temp table ...
      insert into #tmp_dates select <some expression>

      Will complain that 'expr1' is not defined by #tmp_dates. Rather the column definitions should be assumed from the earlier statement.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: