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

AliasSymbol wrapping AliasSymbol error

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 8.7.1.6_2
    • Fix Version/s: 9.0, 8.12.5, 8.13.2
    • Component/s: Query Engine
    • Labels:
      None
    • Environment:

      Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,

      JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157

      64-bit Windows 7 environment

      Description

      I've defined a view and overrode the default triggers for Select, Insert, Update, and Delete. I overrode the triggers because the select is returning "hardcoded" values for a few fields (calling them virtual columns). The Update and Insert triggers will ignore these hardcoded values just in case the caller tries to update a virtual column.

      I'm trying to run a insert into <tableA> select * from <tableB> query. When I run this, I get an error org.teiid.jdbc.TeiidSQLException: Cannot create AliasSymbol wrapping AliasSymbol.

      Facts:
      – I can insert a record if I only select one column from tableB.
      – If I select two or more columns, it throws the error every time.
      – If I remove the overridden triggers, the insert into <tableA> select * from <tableB> works fine.
      – I can insert one or more columns into <tableA> when not using a insert into <tableA> select * from <tableB> query
      – Table A is Oracle
      – Table B is SQL Server

      My hunch is the generated query (hibernate, or whatever SQL generator) is choking with the overridden trigger. Perhaps this use-case slipped through testing, or even more probable, I made a mistake in the trigger creation.

      Here's a snip of the insert trigger, with a lot of fields removed for simplicity.

      FOR EACH ROW
      BEGIN ATOMIC
      	INSERT INTO <schema>.<tableA> (SourceSystemID, RecordTypeID, BatchID ...) 
      	VALUES (
                  convert("NEW".SourceSystemID, short), 
                  convert("NEW".RecordTypeID, short),
                  convert("NEW".BatchID, integer)
                  ...
              )
      END
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                sqtran Steve Tran
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: