MongoDB: EmptyStackException when joining tables ------------------------------------------------ Key: TEIID-3281 URL: https://issues.jboss.org/browse/TEIID-3281 Project: Teiid Issue Type: Bug Components: Connector API Affects Versions: 8.7 Reporter: Filip Elias Assignee: Ramesh Reddy Labels: CR2 Fix For: 8.10 Attachments: mongodb-vdb.xml, server.log Teiid throws java.util.EmptyStackException when joining data from table which has teiid_mongo:MERGE property enabled. Example: {code} insert into customer2 values(1,'Pepa', 'Koukal'); insert into customer2 values(2,'Jan', 'Tlemil'); insert into Address values(1,1,'Pepas Street','Pepas City','Pepas State', 'Pepas zipcode'); insert into Address values(2,2,'Jans Street','Pepa','Jans State', 'Jans zipcode'); {code} {code} select a.*,b.* from customer2 a inner join Address b on a.CustomerId=b.CustomerId order by a.customerID {code} {code} Error: java.util.EmptyStackException at java.util.Stack.peek(Stack.java:102) at java.util.Stack.pop(Stack.java:84) at org.teiid.translator.mongodb.MongoDBSelectVisitor.visit(MongoDBSelectVisitor.java:993) at org.teiid.language.SortSpecification.acceptVisitor(SortSpecification.java:53) at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) at org.teiid.translator.mongodb.MongoDBSelectVisitor.append(MongoDBSelectVisitor.java:112) {code} VDB and log are in the attachment.