QueryResolverException thow in resolving loadMatView ----------------------------------------------------- Key: TEIID-4203 URL: https://issues.jboss.org/browse/TEIID-4203 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 9.0 Reporter: Kylin Soong Assignee: Steven Hawkins Fix For: 9.0 Attachments: server.log The Change in 9.0.0.Beta2-SNAPSHOT cause loadMatView resolving failed {code} Caused by: org.teiid.api.exception.query.QueryResolverException: TEIID31172 Could not resolve expressions being compared to a common type excluding character conversions: VDBVersion = DVARS.vdbVersion at org.teiid.query.resolver.util.ResolverVisitor.resolveCompareCriteria(ResolverVisitor.java:999) at org.teiid.query.resolver.util.ResolverVisitor.visit(ResolverVisitor.java:249) at org.teiid.query.sql.lang.CompareCriteria.acceptVisitor(CompareCriteria.java:130) at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:54) at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:61) at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.postVisitVisitor(SimpleQueryResolver.java:223) at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:135) at org.teiid.query.sql.lang.CompareCriteria.acceptVisitor(CompareCriteria.java:130) at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:63) at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:76) at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:139) at org.teiid.query.sql.lang.CompoundCriteria.acceptVisitor(CompoundCriteria.java:235) at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:63) at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:238) at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:70) at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:273) at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:127) at org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171) ... 22 more {code}