Status: Resolved (View Workflow)
Affects Version/s: 22.214.171.124_2
Component/s: Query Engine
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
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.
– 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.