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

[Paul Nittel (JIRA)]

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