[
https://issues.jboss.org/browse/TEIID-5720?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5720:
---------------------------------------
After updating object to a non-reserved keyword, adding relacl, array_to_string, the 2 arg
obj_description, and ARRAY(subquery), I now see:
\dd \da fail since we don't support pg_catalog.text as a type in cast
\df fails since we don't support generate_series
\dy fails since we don't support unnest (we could map to arrayiterate)
\dD fails since we don't support contypid
\dg \du fail since we don't define pg_roles
\dp and \dT work!
all the rest still fail as their relevant views have not been added. Since we aren't
looking to add full support at this time, I'll just stick with these changes for now
and mark this as partially completed.
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)