Loading...

Type: Bug
Resolution: Done
Priority: Major
Fix Version/s: 11.0, 11.1, 10.3.3
Affects Version/s: 10.2.1
Component/s: Query Engine
Labels:
None
Environment:

teiid-10.2.1 on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)

Steps to Reproduce:
Hide

1. Configure VDB model based on "billofmaterials" table from standard MySQL's AdventureWorks database

<datasource jndi-name="java:/MysqlAdventures" pool-name="mysql-ds" enabled="true"> <connection-url>jdbc:mysql://localhost:3306/adventureworks?useUnicode=true&useJDBCCompliantTimezoneShift=true&serverTimezone=UTC</connection-url> <driver>mysql-connector-java-8.0.11.jar</driver> <security> <user-name>name</user-name> <password>password</password> </security> </datasource>

<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <vdb name="Portfolio" version="1"> <description>MySQL VDB</description> <property name="UseConnectorMetadata" value="true" /> <model name="nw"> <source name="test_tables" translator-name="mylobs" connection-jndi-name="java:/MysqlAdventures"/> <metadata type = "DDL"><![CDATA[ CREATE FOREIGN TABLE billofmaterials ( AssemblyID integer, BillOfMaterialsID integer PRIMARY KEY, ComponentID integer, BOMLevel integer, UnitMeasureCode varchar(3), ObsoleteDate timestamp, ModifiedDate timestamp); ]]> </metadata> </model> <translator name="mylobs" type="mysql5"> <property name="CopyLobs" value="true" /> <property name="SupportsNativeQueries" value="false"/> </translator> </vdb>

Note: it is important that translator type should be the one that has "InlineViews" property enabled, ie "mysql5" but not "mysql"

2. Execute query against the table and make sure no "limit" clause is added by UI tool

select timestampdiff(SQL_TSI_HOUR, ObsoleteDate, storn) as diff, case when UnitMeasureCode='platnosci' or UnitMeasureCode like '%PayU - szybkie%' then 'PAYU' else '' end as payu, case when UnitMeasureCode in ('moneyorder','Przelew bankowy') then 'przelew' else '' end as przelew from (select ObsoleteDate,UnitMeasureCode, MIN(ModifiedDate) as storn from nw.billofmaterials group by ObsoleteDate,UnitMeasureCode ) w

3. Query fails with the stack trace
13:07:59,281 ERROR [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue23) UUzsqpVDE4q1 TEIID30019 Unexpected exception for request UUzsqpVDE4q1.8: java.lang.IndexOutOfBoundsException: Index: 3, Size: 3
at java.util.ArrayList.rangeCheck(ArrayList.java:653)
at java.util.ArrayList.get(ArrayList.java:429)
at org.teiid.query.processor.relational.ProjectNode.updateTuple(ProjectNode.java:188)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:165)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:480)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:350)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:276)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:277)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Show
1. Configure VDB model based on "billofmaterials" table from standard MySQL's AdventureWorks database <datasource jndi-name= "java:/MysqlAdventures" pool-name= "mysql-ds" enabled= "true" > <connection-url> jdbc:mysql://localhost:3306/adventureworks?useUnicode=true&useJDBCCompliantTimezoneShift=true&serverTimezone=UTC </connection-url> <driver> mysql-connector-java-8.0.11.jar </driver> <security> <user-name> name </user-name> <password> password </password> </security> </datasource> <?xml version= "1.0" encoding= "UTF-8" standalone= "yes" ?> <vdb name= "Portfolio" version= "1" > <description> MySQL VDB </description> <property name= "UseConnectorMetadata" value= "true" /> <model name= "nw" > <source name= "test_tables" translator-name= "mylobs" connection-jndi-name= "java:/MysqlAdventures" /> <metadata type = "DDL" > <![CDATA[ CREATE FOREIGN TABLE billofmaterials ( AssemblyID integer, BillOfMaterialsID integer PRIMARY KEY, ComponentID integer, BOMLevel integer, UnitMeasureCode varchar(3), ObsoleteDate timestamp, ModifiedDate timestamp); ]]> </metadata> </model> <translator name= "mylobs" type= "mysql5" > <property name= "CopyLobs" value= "true" /> <property name= "SupportsNativeQueries" value= "false" /> </translator> </vdb> Note: it is important that translator type should be the one that has "InlineViews" property enabled, ie "mysql5" but not "mysql" 2. Execute query against the table and make sure no "limit" clause is added by UI tool select timestampdiff(SQL_TSI_HOUR, ObsoleteDate, storn) as diff, case when UnitMeasureCode= 'platnosci' or UnitMeasureCode like '%PayU - szybkie%' then 'PAYU' else '' end as payu, case when UnitMeasureCode in ( 'moneyorder' , 'Przelew bankowy' ) then 'przelew' else '' end as przelew from ( select ObsoleteDate,UnitMeasureCode, MIN (ModifiedDate) as storn from nw.billofmaterials group by ObsoleteDate,UnitMeasureCode ) w 3. Query fails with the stack trace 13:07:59,281 ERROR [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue23) UUzsqpVDE4q1 TEIID30019 Unexpected exception for request UUzsqpVDE4q1.8: java.lang.IndexOutOfBoundsException: Index: 3, Size: 3 at java.util.ArrayList.rangeCheck(ArrayList.java:653) at java.util.ArrayList.get(ArrayList.java:429) at org.teiid.query.processor.relational.ProjectNode.updateTuple(ProjectNode.java:188) at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:165) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:480) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:350) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:276) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:277) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)

Details

Attachments

Easy Agile Planning Poker

Activity

People

Dates