[teiid-issues] [JBoss JIRA] (TEIID-4203) QueryResolverException thow in resolving loadMatView

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13237721#comment-13237721 ] 

Steven Hawkins commented on TEIID-4203:
---------------------------------------

Related to TEIID-3999 this could be resolved with an initial validation that the status table definition matches our expectation.

> 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}



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)