[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=13205296#comment-13205296 ] 

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

This is related to TEIID-3462 - it's documented in the migration guide that your status tables need to have the version field modified to be a string, rather than an integer.  If needed we can try to be more accommodating for backwards compatibility, but that will only work as long as all of the vdbs use the integer style versions - the first one that has a semantic version would then be a problem.

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