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

Creating a temp table gets error that Cannot create temporary table "dddd". A table with the same name already exists.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 7.4.1, 7.5
    • 7.4
    • Query Engine
    • None

      Logging into a VDB using SQuirreL, I entered: create local temporary table dddd (id string, name string)

      What I received was: Cannot create temporary table "dddd". A table with the same name already exists.

      There appears to be no way to create a temporary table, using this method. SELECT * INTO #temp from ... does work, however.

              rhn-engineering-shawkins Steven Hawkins
              pnittel_jira Paul Nittel (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: