[teiid-issues] [JBoss JIRA] (TEIID-5720) PSQL client fails to report the metadata

[Steven Hawkins (Jira)]

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

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)