April 2019 - teiid-issues - Jboss List Archives

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

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5720?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5720: --------------------------------------- For reference the describe source: https://github.com/postgres/postgres/blob/421a2c48328c88eb31f6b29979218f0... > 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 > Fix For: 12.2 > > > 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)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5618) clientHostName always reported as localhost via JDBC connection

by Andrej Smigala (Jira)

[ https://issues.jboss.org/browse/TEIID-5618?page=com.atlassian.jira.plugin... ] Andrej Smigala updated TEIID-5618: ---------------------------------- Attachment: (was: screenshot-1.png) > clientHostName always reported as localhost via JDBC connection > --------------------------------------------------------------- > > Key: TEIID-5618 > URL: https://issues.jboss.org/browse/TEIID-5618 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.12.16.6_4 > Reporter: Deborah Steigner > Assignee: Steven Hawkins > Priority: Major > Fix For: 8.12.17.6_4, 12.1 > > > VDB session information in the Management Console and logs shows localhost for Client Host Name with a JDBC connection. > Client Host Name: localhost > Client Hardware Address: 4CBB58502284 > IP Address: > Security Domain: teiid-security > In the server.log with org.teiid set to TRACE it displays below for session: > DEBUG [org.teiid.SECURITY] (New I/O worker #2) Logon successful, created session: sessionid=DW9hzUw5P1ob; userName=teiidUser@teiid-security; vdbName=deb_pg; vdbVersion=2; createdTime=Thu Jan 17 08:15:44 CST 2019; applicationName=JDBC; clientHostName=localhost; clientHardwareAddress=4CBB58502284; IPAddress=192.168.x.x; securityDomain=teiid-security; lastPingTime=Thu Jan 17 08:15:44 CST 2019 -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5618) clientHostName always reported as localhost via JDBC connection

by Andrej Smigala (Jira)

[ https://issues.jboss.org/browse/TEIID-5618?page=com.atlassian.jira.plugin... ] Andrej Smigala updated TEIID-5618: ---------------------------------- Attachment: screenshot-1.png > clientHostName always reported as localhost via JDBC connection > --------------------------------------------------------------- > > Key: TEIID-5618 > URL: https://issues.jboss.org/browse/TEIID-5618 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.12.16.6_4 > Reporter: Deborah Steigner > Assignee: Steven Hawkins > Priority: Major > Fix For: 8.12.17.6_4, 12.1 > > Attachments: screenshot-1.png > > > VDB session information in the Management Console and logs shows localhost for Client Host Name with a JDBC connection. > Client Host Name: localhost > Client Hardware Address: 4CBB58502284 > IP Address: > Security Domain: teiid-security > In the server.log with org.teiid set to TRACE it displays below for session: > DEBUG [org.teiid.SECURITY] (New I/O worker #2) Logon successful, created session: sessionid=DW9hzUw5P1ob; userName=teiidUser@teiid-security; vdbName=deb_pg; vdbVersion=2; createdTime=Thu Jan 17 08:15:44 CST 2019; applicationName=JDBC; clientHostName=localhost; clientHardwareAddress=4CBB58502284; IPAddress=192.168.x.x; securityDomain=teiid-security; lastPingTime=Thu Jan 17 08:15:44 CST 2019 -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5727) Add bound functions and procedures to Teiid

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5727?page=com.atlassian.jira.plugin... ] Steven Hawkins reassigned TEIID-5727: ------------------------------------- Assignee: (was: Steven Hawkins) > Add bound functions and procedures to Teiid > ------------------------------------------- > > Key: TEIID-5727 > URL: https://issues.jboss.org/browse/TEIID-5727 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Priority: Optional > Fix For: Open To Community > > > As far as I understood virtual procedures and functions are unbound only in the current implementation in Teiid. Would be nice if there would be a option to have bound (to entities and entity sets) procedures and functions as well. > This would allow for some more syntactic sugar and would allow for a closer integration with libraries such as SAPUI5. See here for an example > https://sapui5.netweaver.ondemand.com/sdk/#/topic/b54f7895b7594c61a83fa72... -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5727) Add bound functions and procedures to Teiid

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5727?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5727: ---------------------------------- Fix Version/s: Open To Community > Add bound functions and procedures to Teiid > ------------------------------------------- > > Key: TEIID-5727 > URL: https://issues.jboss.org/browse/TEIID-5727 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Optional > Fix For: Open To Community > > > As far as I understood virtual procedures and functions are unbound only in the current implementation in Teiid. Would be nice if there would be a option to have bound (to entities and entity sets) procedures and functions as well. > This would allow for some more syntactic sugar and would allow for a closer integration with libraries such as SAPUI5. See here for an example > https://sapui5.netweaver.ondemand.com/sdk/#/topic/b54f7895b7594c61a83fa72... -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5725: --------------------------------------- > And one further question, do I need to drop the temporary table after I am finished? An implicitly created # temp table is a Teiid local temporary table. Teiid local temporary tables will be dropped when their containing procedure block completes, or when the session ends if they are created at the top level. > Please improve documentation on definition of stored procedures, virtual functions and virtual procedures > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-5725 > URL: https://issues.jboss.org/browse/TEIID-5725 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Critical > > I refer to the discussion with Ramesh in > https://developer.jboss.org/message/989048#989048 and would like to ask for a more detailed explanation on how to write virtual procedures and functions. > -Especially, how are OUT and INOUT params set and how can they be obtained via odata. > - How is the return value of a virtual function set? > - How are collections and arrays of collections returned? -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

by Christoph John (Jira)

[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin... ] Christoph John commented on TEIID-5725: --------------------------------------- Well supporting VS Code would be very helpful indeed. However, I assume once the support is there, I will have learned the syntax :) > Please improve documentation on definition of stored procedures, virtual functions and virtual procedures > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-5725 > URL: https://issues.jboss.org/browse/TEIID-5725 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Critical > > I refer to the discussion with Ramesh in > https://developer.jboss.org/message/989048#989048 and would like to ask for a more detailed explanation on how to write virtual procedures and functions. > -Especially, how are OUT and INOUT params set and how can they be obtained via odata. > - How is the return value of a virtual function set? > - How are collections and arrays of collections returned? -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5725: --------------------------------------- > I do not like this trail and error principle. Teiid Designer was the path for helping with editing. Ideally we'll explore VS Code for VDB authoring in the near term. > Is the SQL syntax implemented in TEIID something custom? The procedure language was developed many years ago loosely based upon pl/sql, and also influenced by SQL Server (select into, option clause, etc.). > I have red in the docs it would adhere to sql-92 syntax The DML part follows SQL 92 and later closely. Newer elements of the procedure language followed the spec more closely, but ultimately it's custom. > Please improve documentation on definition of stored procedures, virtual functions and virtual procedures > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-5725 > URL: https://issues.jboss.org/browse/TEIID-5725 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Critical > > I refer to the discussion with Ramesh in > https://developer.jboss.org/message/989048#989048 and would like to ask for a more detailed explanation on how to write virtual procedures and functions. > -Especially, how are OUT and INOUT params set and how can they be obtained via odata. > - How is the return value of a virtual function set? > - How are collections and arrays of collections returned? -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

by Christoph John (Jira)

[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin... ] Christoph John edited comment on TEIID-5725 at 4/23/19 4:32 PM: ---------------------------------------------------------------- Thanks a lot Steven, I am currently reading through the SQL documentation and try to get different things working. However, whatever I am trying my syntax always seems to be wrong. I do not like this trail and error principle. Is the SQL syntax implemented in TEIID something custom? Or does it adhere to a standard, I have red in the docs it would adhere to sql-92 syntax. Is this really the case? In that case I have to find different tutorials :) And one further question, do I need to drop the temporary table after I am finished? was (Author: cjohn001): Thanks a lot Steven, I am currently reading through the SQL documentation and try to get different things working. However, whatever I am trying my syntax always seems to be wrong. I do not like this trail and error principle. Is the SQL syntax implemented in TEIID something custom? Or does it adhere to a standard, I have red in the docs it would adhere to sql-92 syntax. Is this really the case? In that case I have to find different tutorials :) > Please improve documentation on definition of stored procedures, virtual functions and virtual procedures > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-5725 > URL: https://issues.jboss.org/browse/TEIID-5725 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Critical > > I refer to the discussion with Ramesh in > https://developer.jboss.org/message/989048#989048 and would like to ask for a more detailed explanation on how to write virtual procedures and functions. > -Especially, how are OUT and INOUT params set and how can they be obtained via odata. > - How is the return value of a virtual function set? > - How are collections and arrays of collections returned? -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

by Christoph John (Jira)

[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin... ] Christoph John commented on TEIID-5725: --------------------------------------- Thanks a lot Steven, I am currently reading through the SQL documentation and try to get different things working. However, whatever I am trying my syntax always seems to be wrong. I do not like this trail and error principle. Is the SQL syntax implemented in TEIID something custom? Or does it adhere to a standard, I have red in the docks it would adhere to sql-92 syntax. Is this really the case? In that case I have to find different tutorials :) > Please improve documentation on definition of stored procedures, virtual functions and virtual procedures > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-5725 > URL: https://issues.jboss.org/browse/TEIID-5725 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Critical > > I refer to the discussion with Ramesh in > https://developer.jboss.org/message/989048#989048 and would like to ask for a more detailed explanation on how to write virtual procedures and functions. > -Especially, how are OUT and INOUT params set and how can they be obtained via odata. > - How is the return value of a virtual function set? > - How are collections and arrays of collections returned? -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2019