[teiid-issues] [JBoss JIRA] (TEIID-2093) MAKEDEP causes AssertionError

[Johnathon Lee (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12704854#comment-12704854 ] 

Johnathon Lee commented on TEIID-2093:
--------------------------------------

Went back to simplyfying the case,  note that you can define the transformation [1] and set the translator to loopback to avoid step 1) and still raise the java.lang.AssertionError

[1]
SELECT
  'x' AS X
FROM
  DBB.DBB.B AS b, /*+ MAKEDEP */ (SELECT DISTINCT a.ID, a.BOOK, a.BUSINESS_DATE FROM DBA.DBA.A AS a) AS aa
WHERE
  (b.ID = aa.ID) AND (aa.BOOK = b.BOOK) AND (aa.BUSINESS_DATE = {d'2012-07-04'})
                
> MAKEDEP causes AssertionError
> -----------------------------
>
>                 Key: TEIID-2093
>                 URL: https://issues.jboss.org/browse/TEIID-2093
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.4.1
>         Environment: openjdk 1.6.0_24
> EDS 5.2
>            Reporter: Hisanobu Okuda
>            Assignee: Steven Hawkins
>         Attachments: create_db.sql, IVTest.zip, server.log.1
>
>
> When /*+ MAKEDEP */ is in a query, AssertionError is thrown :-
> 2012-07-06 06:55:34,984 ERROR [org.teiid.CONNECTOR] (Worker68_QueryProcessorQueue220) Connector worker process failed for atomic-request=+ccfiekJpQHH.0.4.69
> java.lang.AssertionError
> 	at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:313)
> 	at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:348)
> 	at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:297)
> 	at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:213)
> 	at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:154)
> 	at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:285)
> 	at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:249)
> 	at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:210)
> 	at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:135)
> 	at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:217)
> 	at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338)
> 	at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:80)
> 	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138)
> 	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:135)
> 	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> 	at java.util.concurrent.FutureTask.run(FutureTask.java:166)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira