Internal Mat View of table with Primary Key gets dpulicate key error when populating temporary mat view table ------------------------------------------------------------------------------------------------------------- Key: TEIID-1348 URL: https://jira.jboss.org/browse/TEIID-1348 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1.1 Environment: Fedora 12, SOA-P ER3, JBDS 4.0 Beta1 Reporter: Paul Nittel Assignee: Steven Hawkins Fix For: 7.1.1 I was testing Internal Materialized Views when I encountered this. I had modeled a bookInfo (books and publishers) view with a PK of the ISBN column. This was cloned to SonOfbookInfo and materialized views set to true. I deployed this in a VDB and queried with SQuirreL: select title from BooksInfo.SonOfbookInfo This resulted in a duplicate key error (excerpt below... whole log is attached.) 2010-11-04 10:50:16,450 ERROR [org.teiid.PROCESSOR.MATVIEWS] (Worker99_QueryProcessorQueue3659) Failed to load materialized view table #MAT_BOOKSINFO.SONOFBOOKINFO. [TeiidProcessingException]Duplicate key at org.teiid.query.tempdata.TempTable.insertTuple(TempTable.java:550) at org.teiid.query.tempdata.TempTable.access$200(TempTable.java:71) at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.tuplePassed(TempTable.java:106) at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:207) at org.teiid.query.tempdata.TempTable.insert(TempTable.java:446) at org.teiid.query.tempdata.TempTableDataManager.loadGlobalTable(TempTableDataManager.java:513) at org.teiid.query.tempdata.TempTableDataManager.registerQuery(TempTableDataManager.java:410) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:182) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:170) at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:197) at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:118) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.LimitNode.open(LimitNode.java:110) at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:98) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:134) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:249) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:183) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:189) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira