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: