Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2381

Error with virtual procedure inserting into global temporary table

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • None
    • 8.6
    • Transformations
    • None
    • Hide

      1. Create a view model
      2. Create a global temporary table in the model from step #1
      3. Try to create a procedure in the same model, in the transformation editor insert query similar to: INSERT INTO <ModelName>.<GlobalTempTableName>(<Column>,..) VALUES (<Value1>,...), save the editor content.

      Show
      1. Create a view model 2. Create a global temporary table in the model from step #1 3. Try to create a procedure in the same model, in the transformation editor insert query similar to: INSERT INTO <ModelName>.<GlobalTempTableName>(<Column>,..) VALUES (<Value1>,...), save the editor content.

      I have a view model (called IPView) with global temporary table (called global_temp_table), then I have virtual procedure in the same model where I try to insert data into the global temporary table. When the Transformation Editor's content is saved, it displays an error under the editor's text area. The error has following message:
      ERROR: TEIID30065 Error parsing query plan transformation for IPView.global_temp_table
      This error does not give the user any hint what went wrong (what he did wrong).

            Unassigned Unassigned
            jstastny@redhat.com Jan Stastny
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: