[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1348) Internal Mat View of table with Primary Key gets duplicate key error when populating temporary mat view table

Internal Mat View of table with Primary Key gets duplicate 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 Attachments: MatViewMania_SonOf_MPS.zip, server.log.2010-11-04-10 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)