April 2019 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5406) Allow usage of long datatype as the increment parameter in TimestampAdd function

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5406?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5406: --------------------------------------- > do I understand correctly that some of DB still can treat the fractional second parameter as Integer type? That's why you added the check on Integer range? Yes, most sources and even assumptions made by our translators treated that effectively as an integer value. > Allow usage of long datatype as the increment parameter in TimestampAdd function > -------------------------------------------------------------------------------- > > Key: TEIID-5406 > URL: https://issues.jboss.org/browse/TEIID-5406 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 10.2 > Environment: teiid-10.2.0 on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Major > Fix For: 11.1 > > > Currently the TIMESTAMPADD(interval, count, timestamp) expects the count parameter to be integer. This is inconsistent with the return value of the TIMSTAMPDIFF function that is long. Thus we cannot take the fraction of the count returned by TIMSTAMPDIFF and submit it to TIMESTAMPADD. Since the SQL_TSI_FRAC_SECOND difference is too large for most human values (and it's the only way to retrieve millis, even though millions of millis), we need a way to submit this data to TIMSTAMPADD. > 1. There is an inconsistency when adding 1 billion fractions of a second. Please execute the script below, one adds one billion minus one, the next one exactly 1bln fractions which results in two values, one of which is 1 fraction larger than expected: > {code:sql} > Select TimestampAdd(SQL_TSI_FRAC_SECOND, 999999999, Cast(CurDate() as timestamp)) > Union All > Select TimestampAdd(SQL_TSI_FRAC_SECOND, 999999999 + 1, Cast(CurDate() as timestamp));; > {code} > 2. Another example: > {code:sql} > Begin > Declare timestamp initialDate = CurDate(); > Declare long diff = TimestampDiff(SQL_TSI_FRAC_SECOND, initialDate, TimestampAdd(SQL_TSI_DAY, 1, initialDate)); > Declare timestamp back = TimestampAdd(SQL_TSI_FRAC_SECOND, diff, initialDate); > select initialDate, back; > End ;; > {code} > which leads to the following error message: > {code:noformat} > 2018-07-03 10:10:33,942 WARN [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue47) 1RBg/ooz5vx7 TEIID30020 Processing exception for request 1RBg/ooz5vx7.27 'TEIID30070 The function > 'TimestampAdd(SQL_TSI_FRAC_SECOND, VARIABLES.diff, VARIABLES.initialDate)' is a valid function form, but the arguments do not match a known type signature and cannot be converted usi > ng implicit type conversions.'. Originally QueryResolverException ResolverVisitor.java:757.: org.teiid.api.exception.query.QueryResolverException: TEIID30070 The function 'TimestampA > dd(SQL_TSI_FRAC_SECOND, VARIABLES.diff, VARIABLES.initialDate)' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit > type conversions. > at org.teiid.query.resolver.util.ResolverVisitor.resolveFunction(ResolverVisitor.java:757) > at org.teiid.query.resolver.util.ResolverVisitor.visit(ResolverVisitor.java:392) > at org.teiid.query.sql.symbol.Function.acceptVisitor(Function.java:169) > 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.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:194) > at org.teiid.query.sql.symbol.Function.acceptVisitor(Function.java:169) > at org.teiid.query.resolver.util.ResolverVisitor.resolveLanguageObject(ResolverVisitor.java:1456) > at org.teiid.query.resolver.command.UpdateProcedureResolver.resolveStatement(UpdateProcedureResolver.java:234) > at org.teiid.query.resolver.command.UpdateProcedureResolver.resolveBlock(UpdateProcedureResolver.java:127) > at org.teiid.query.resolver.command.UpdateProcedureResolver.resolveCommand(UpdateProcedureResolver.java:110) > at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:282) > at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:128) > 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:660) > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339) > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47) > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:276) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:277) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > {code} -- This message was sent by Atlassian Jira (v7.12.1#712002)

7 years

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-63) Support Keycloak based OpenID authentication for OData Through 3scale

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-63?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIIDSB-63: --------------------------------------- I was assuming you wanted this to cover the group/role parsing from the token as well. Do you want a separate issue on authorization? > Support Keycloak based OpenID authentication for OData Through 3scale > --------------------------------------------------------------------- > > Key: TEIIDSB-63 > URL: https://issues.jboss.org/browse/TEIIDSB-63 > Project: Teiid Spring Boot > Issue Type: Feature Request > Reporter: Ramesh Reddy > Priority: Major > > Support the authentication for OData through 3scale -- This message was sent by Atlassian Jira (v7.12.1#712002)

7 years

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-63) Support Keycloak based OpenID authentication for OData Through 3scale

by Ramesh Reddy (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-63?page=com.atlassian.jira.plugin... ] Ramesh Reddy reassigned TEIIDSB-63: ----------------------------------- Assignee: (was: Steven Hawkins) > Support Keycloak based OpenID authentication for OData Through 3scale > --------------------------------------------------------------------- > > Key: TEIIDSB-63 > URL: https://issues.jboss.org/browse/TEIIDSB-63 > Project: Teiid Spring Boot > Issue Type: Feature Request > Reporter: Ramesh Reddy > Priority: Major > > Support the authentication for OData through 3scale -- This message was sent by Atlassian Jira (v7.12.1#712002)

7 years

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-63) Support Keycloak based OpenID authentication for OData Through 3scale

by Ramesh Reddy (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-63?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIIDSB-63: ------------------------------------- [~shawkins] I mistakenly added in Teiid, as there should be nothing more coding wise we need to do but it requires testing with 3scale. We would need to expand the current example with new updates. > Support Keycloak based OpenID authentication for OData Through 3scale > --------------------------------------------------------------------- > > Key: TEIIDSB-63 > URL: https://issues.jboss.org/browse/TEIIDSB-63 > Project: Teiid Spring Boot > Issue Type: Feature Request > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Priority: Major > > Support the authentication for OData through 3scale -- This message was sent by Atlassian Jira (v7.12.1#712002)

7 years

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-63) Support Keycloak based OpenID authentication for OData Through 3scale

by Ramesh Reddy (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-63?page=com.atlassian.jira.plugin... ] Ramesh Reddy moved TEIID-5702 to TEIIDSB-63: -------------------------------------------- Project: Teiid Spring Boot (was: Teiid) Key: TEIIDSB-63 (was: TEIID-5702) Issue Type: Feature Request (was: Enhancement) > Support Keycloak based OpenID authentication for OData Through 3scale > --------------------------------------------------------------------- > > Key: TEIIDSB-63 > URL: https://issues.jboss.org/browse/TEIIDSB-63 > Project: Teiid Spring Boot > Issue Type: Feature Request > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Priority: Major > > Support the authentication for OData through 3scale -- This message was sent by Atlassian Jira (v7.12.1#712002)

7 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5702) Support Keycloak based OpenID authentication for OData Through 3scale

by Ramesh Reddy (Jira)

[ https://issues.jboss.org/browse/TEIID-5702?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-5702: -------------------------------- Summary: Support Keycloak based OpenID authentication for OData Through 3scale (was: Support Keycloak based OAuth authentication for OData Through 3scale) > Support Keycloak based OpenID authentication for OData Through 3scale > --------------------------------------------------------------------- > > Key: TEIID-5702 > URL: https://issues.jboss.org/browse/TEIID-5702 > Project: Teiid > Issue Type: Enhancement > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Priority: Major > > Support the authentication for OData through 3scale -- This message was sent by Atlassian Jira (v7.12.1#712002)

7 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5704) Support openapi 3 sources

by Steven Hawkins (Jira)

Steven Hawkins created TEIID-5704: ------------------------------------- Summary: Support openapi 3 sources Key: TEIID-5704 URL: https://issues.jboss.org/browse/TEIID-5704 Project: Teiid Issue Type: Enhancement Components: Misc. Connectors Reporter: Steven Hawkins Assignee: Steven Hawkins It seems like a good idea to introduce a new translator, rather than trying to fit openapi 3 support onto the swagger translator - as the io.swagger libraries and a lot of logic will be different. -- This message was sent by Atlassian Jira (v7.12.1#712002)

7 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5703) Pushing sorted limit should reuse interesting order

by Steven Hawkins (Jira)

Steven Hawkins created TEIID-5703: ------------------------------------- Summary: Pushing sorted limit should reuse interesting order Key: TEIID-5703 URL: https://issues.jboss.org/browse/TEIID-5703 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 12.x When an order limit is pushed: select ... from a left outer join b ... order by a.x limit 10 we effectively create select ... from (select ... from a order by a.x limit 10 ) as a left outer join b ... order by a.x limit 10 such that the order and limit is reapplied. In many cases the order by is the same as rows contained in the join predicate, or we can use a hash/index of the inner side such that the order of the outer remains stable. It's a smaller issue, but it's possible that the higher level limit is also not necessary - if there can only be 0-1 inner rows per outer. -- This message was sent by Atlassian Jira (v7.12.1#712002)

7 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5690) getVDBs in domain mode is returning the VDBs of one cluster

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5690?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5690: ---------------------------------- Component/s: AdminApi Fix Version/s: 12.2 > getVDBs in domain mode is returning the VDBs of one cluster > ----------------------------------------------------------- > > Key: TEIID-5690 > URL: https://issues.jboss.org/browse/TEIID-5690 > Project: Teiid > Issue Type: Bug > Components: AdminApi > Reporter: Mark Tawk > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.2 > > > The method "getDomainAwareList" used into "getVDBs()" is always used with the parameter "singleInstance" set to true. > That's why "getVDBs()" is returning only the VDBs of one cluster. > or "singleInstance" should be set to false when having multiple clusters -- This message was sent by Atlassian Jira (v7.12.1#712002)

7 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5702) Support Keycloak based OAuth authentication for OData Through 3scale

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5702?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5702: --------------------------------------- This would be to support openid connect correct? Do you want to clone this issue over to TEIIDSB as well? > Support Keycloak based OAuth authentication for OData Through 3scale > -------------------------------------------------------------------- > > Key: TEIID-5702 > URL: https://issues.jboss.org/browse/TEIID-5702 > Project: Teiid > Issue Type: Enhancement > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Priority: Major > > Support the authentication for OData through 3scale -- This message was sent by Atlassian Jira (v7.12.1#712002)

7 years

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