1:04 p.m.
[
https://issues.jboss.org/browse/TEIID-5720?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5720:
---------------------------------------
\d \dt \dS - now work
\dd fails since the reserved word object is being used as an alias
\df \dy \dD \dg \du fails as we don't like the array constructor ARRAY( and we
don't define pg_catalog.array_to_string
\dL fails as we don't define a pg_catalog.pg_language
\dT fails since we don't support the two argument pg_catalog.obj_description
\da fails since we don't support pg_catalog.text as an alias in that context - we have
added some support for aliases with ., so this is just another case not yet covered.
\db fails since we don't define pg_tablesspace
\dC fails since we don't define pg_cast
\dl fails since we don't define pg_largeobject
\do fails since we don't define pg_operator
\dp fails since we don't define the relacl column
This also highlights that we'll need to move our reported server version consistently
ahead in the near future to 8.4+. 8.2 is not 13 years old and many of the \d commands
don't work against that old of a version.
I'll tack on a fix for the lowest hanging fruit above and we can document the other
limitations.
PSQL client fails to report the metadata
----------------------------------------
Key: TEIID-5720
URL: https://issues.jboss.org/browse/TEIID-5720
Project: Teiid
Issue Type: Bug
Components: ODBC
Reporter: Ramesh Reddy
Assignee: Steven Hawkins
Priority: Major
When using psql client and issuing the "\dt" command I see this exception
instead of returning the table names.
{code}
WARN: TEIID30020 Processing exception for request grF9mx6fyMfD.1 'TEIID30082 Expected
value of type 'char' but '''' is of type 'string' and no
implicit conversion is available.'. Originally QueryResolverException
ResolverUtil.java:230.
org.teiid.api.exception.query.QueryResolverException: TEIID30082 Expected value of type
'char' but '''' is of type 'string' and no implicit
conversion is available.
at org.teiid.query.resolver.util.ResolverUtil.convertExpression(ResolverUtil.java:230)
at
org.teiid.query.resolver.util.ResolverVisitor.resolveSetCriteria(ResolverVisitor.java:1203)
at org.teiid.query.resolver.util.ResolverVisitor.visit(ResolverVisitor.java:294)
at org.teiid.query.sql.lang.SetCriteria.acceptVisitor(SetCriteria.java:96)
at
org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:50)
at
org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:57)
at
org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.postVisitVisitor(SimpleQueryResolver.java:229)
at
org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:345)
at org.teiid.query.sql.lang.SetCriteria.acceptVisitor(SetCriteria.java:96)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:59)
at
org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:72)
at
org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:135)
at org.teiid.query.sql.lang.CompoundCriteria.acceptVisitor(CompoundCriteria.java:231)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:59)
at
org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:244)
at
org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:66)
at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:178)
at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:120)
at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:282)
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:418)
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:486)
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:672)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:351)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:43)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:285)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:281)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:124)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$2.run(ThreadReuseExecutor.java:212)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
{code}
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
2071
days inactive
2071
days old
0 comments
1 participants
participants (1)
-
Steven Hawkins (Jira)