[JBoss JIRA] (TEIID-4112) ORA-32039: recursive WITH clause must have column alias list
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-4112?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-4112:
------------------------------------------------
Andrej Smigala <asmigala(a)redhat.com> changed the Status of [bug 1322935|https://bugzilla.redhat.com/show_bug.cgi?id=1322935] from ON_QA to ASSIGNED
> ORA-32039: recursive WITH clause must have column alias list
> ------------------------------------------------------------
>
> Key: TEIID-4112
> URL: https://issues.jboss.org/browse/TEIID-4112
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector, Query Engine
> Affects Versions: 8.7.2.6_2
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.7.6.6_2
>
>
> If running a WITH table AS(...) query to Oracle and the query schema name is the same as the subquery name i.e. EWI. you receive the Oracle error:
> ORA-32039: recursive WITH clause must have column alias list
> If you modify the query to
> WITH EWI1 AS ....
> then it works.
> f.ex:
> breaking: WITH tbl AS (
> where tbl = a common table name in the current schema and the common table definition as (...) references a view in that schema. Oracle will complain with this erroneous error.
> work-around: WITH tbl_1 AS(
> where tbl_1 does not exist as a current schema/table name.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-4203) QueryResolverException thow in resolving loadMatView
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4203?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-4203:
------------------------------------
I have update quickstart and embedded example to make the change compatible.
> 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)
8 years, 7 months
[JBoss JIRA] (TEIID-3999) more aspects of materialization metadata should be validated
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3999?page=com.atlassian.jira.plugin... ]
Kylin Soong updated TEIID-3999:
-------------------------------
Description:
* During metadata load we should check if the status table and the materialization scripts are valid, so there is at least a log of the issue rather than waiting for the exception to occur once the vdb is active.
* According to TEIID-4203, add an initial validation that validate the status table definition matches the expectation.
was:During metadata load we should check if the status table and the materialization scripts are valid, so there is at least a log of the issue rather than waiting for the exception to occur once the vdb is active.
> more aspects of materialization metadata should be validated
> ------------------------------------------------------------
>
> Key: TEIID-3999
> URL: https://issues.jboss.org/browse/TEIID-3999
> Project: Teiid
> Issue Type: Quality Risk
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Kylin Soong
> Priority: Minor
> Fix For: 9.1
>
>
> * During metadata load we should check if the status table and the materialization scripts are valid, so there is at least a log of the issue rather than waiting for the exception to occur once the vdb is active.
> * According to TEIID-4203, add an initial validation that validate the status table definition matches the expectation.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-3946) Version negotiation in JDBC connection
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3946?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3946:
----------------------------------
Fix Version/s: 9.1
(was: 9.0)
Priority: Minor (was: Major)
Deferring until we get more information.
> Version negotiation in JDBC connection
> --------------------------------------
>
> Key: TEIID-3946
> URL: https://issues.jboss.org/browse/TEIID-3946
> Project: Teiid
> Issue Type: Feature Request
> Components: JDBC Driver
> Affects Versions: 8.7.4
> Environment: - JDV 6.2
> Reporter: Hisanobu Okuda
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 9.1
>
>
> Our customer is providing a service on top of JDV and some of the external clients are still using outdated teiid drivers and wants something they can make for JDV to block a connection if the JDBC Driver used in a client is outdated. This scenario occurs everytime the customer updates JDV. Since there are so much external clients, some of them don't update their JDBC Drivers and this leads to some errors in JDV.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-4203) QueryResolverException thow in resolving loadMatView
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4203?page=com.atlassian.jira.plugin... ]
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)
8 years, 7 months
[JBoss JIRA] (TEIID-3946) Version negotiation in JDBC connection
by Marcelo Guimarães (JIRA)
[ https://issues.jboss.org/browse/TEIID-3946?page=com.atlassian.jira.plugin... ]
Marcelo Guimarães commented on TEIID-3946:
------------------------------------------
I'm trying to get the information. They don't have the logs and the logs I have didn't show the full stacktrace.
It's being difficult because they've updated JDV and, since the error don't occur anymore, they don't have records of it now. (Even ETL tools is difficult because it's happening on a "third party customer" - they're using JDV to provide Data as a Service so the ETL tools is from their customers.)
Sorry for the trouble here.
> Version negotiation in JDBC connection
> --------------------------------------
>
> Key: TEIID-3946
> URL: https://issues.jboss.org/browse/TEIID-3946
> Project: Teiid
> Issue Type: Feature Request
> Components: JDBC Driver
> Affects Versions: 8.7.4
> Environment: - JDV 6.2
> Reporter: Hisanobu Okuda
> Assignee: Steven Hawkins
> Fix For: 9.0
>
>
> Our customer is providing a service on top of JDV and some of the external clients are still using outdated teiid drivers and wants something they can make for JDV to block a connection if the JDBC Driver used in a client is outdated. This scenario occurs everytime the customer updates JDV. Since there are so much external clients, some of them don't update their JDBC Drivers and this leads to some errors in JDV.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-4203) QueryResolverException thow in resolving loadMatView
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4203?page=com.atlassian.jira.plugin... ]
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)
8 years, 7 months
[JBoss JIRA] (TEIID-4203) QueryResolverException thow in resolving loadMatView
by Kylin Soong (JIRA)
Kylin Soong created TEIID-4203:
----------------------------------
Summary: 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)
8 years, 7 months