August 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5457) Issues with sybase/ms sql pad pushdown

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5457?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5457: ---------------------------------- Description: Sybase will return a non-null result then padding a null string. Sybase and ms sql will trim from the string from the left when lpad is specified with a pad length shorter than the string. The expected behavior is to always trim from the right. The length of the total string is also not computed correctly. was: Sybase will return a non-null result then padding a null string. Sybase and ms sql will trim from the string from the left when lpad is specified with a pad length shorter than the string. The expected behavior is to always trim from the right. > Issues with sybase/ms sql pad pushdown > -------------------------------------- > > Key: TEIID-5457 > URL: https://issues.jboss.org/browse/TEIID-5457 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 11.1 > > > Sybase will return a non-null result then padding a null string. > Sybase and ms sql will trim from the string from the left when lpad is specified with a pad length shorter than the string. The expected behavior is to always trim from the right. > The length of the total string is also not computed correctly. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4761) Support lpad/rpad pushdown to sql server

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4761?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4761. ----------------------------------- Resolution: Done > Support lpad/rpad pushdown to sql server > ---------------------------------------- > > Key: TEIID-4761 > URL: https://issues.jboss.org/browse/TEIID-4761 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12.15.6_4, 9.3 > > > lpad/rpad is not pushded down to sql server since it lacked a direct equivalent - but it can be supported with an expression. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4761) Support lpad/rpad pushdown to sql server

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4761?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4761: ---------------------------------- Comment: was deleted (was: After looking at this more, this should be addressed under the original issue.) > Support lpad/rpad pushdown to sql server > ---------------------------------------- > > Key: TEIID-4761 > URL: https://issues.jboss.org/browse/TEIID-4761 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3, 8.12.15.6_4 > > > lpad/rpad is not pushded down to sql server since it lacked a direct equivalent - but it can be supported with an expression. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4761) Support lpad/rpad pushdown to sql server

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4761?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-4761: ----------------------------------- After looking at this more, this should be addressed under the original issue. > Support lpad/rpad pushdown to sql server > ---------------------------------------- > > Key: TEIID-4761 > URL: https://issues.jboss.org/browse/TEIID-4761 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3, 8.12.15.6_4 > > > lpad/rpad is not pushded down to sql server since it lacked a direct equivalent - but it can be supported with an expression. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5444) Upgrade to Olingo-4.5

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-5444?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-5444. --------------------------------- Resolution: Done Seems to be the changes are allowed per OData spec leads, so modified our test to reflect the functionality. > Upgrade to Olingo-4.5 > --------------------- > > Key: TEIID-5444 > URL: https://issues.jboss.org/browse/TEIID-5444 > Project: Teiid > Issue Type: Task > Components: Build/Kits > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 11.1 > > > Upgrade the olingo library to latest 4.5 version -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5343) Enable absolute URI on context definition of EntitySets when using ODATA

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-5343?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-5343. --------------------------------- Resolution: Done See TEIID-5444 > Enable absolute URI on context definition of EntitySets when using ODATA > ------------------------------------------------------------------------ > > Key: TEIID-5343 > URL: https://issues.jboss.org/browse/TEIID-5343 > Project: Teiid > Issue Type: Enhancement > Components: OData > Affects Versions: 10.2.1 > Reporter: Rafael Sampaio > Assignee: Ramesh Reddy > Fix For: 11.1 > > > Hi all you TEIID guys. > As reported on [OLINGO-1025|https://issues.apache.org/jira/browse/OLINGO-1025], integrating to MS OData consumers (ie. PowerBI/PowerQuery) gives the "should be an absolute Uri" error. > The proposed solution in the JIRA is implementing a Processor for any given EntityType. Browsing through the code i see TEIID uses the ServiceHandler approach, instead of processor and it also has a Custom JSON Odata Serializer. > I see that the Default JSON serializer, when serializing entity collections uses the ContextURL to generate the context metadata for the EntityCollection, but by default it does not contain the service root, since it comes from static DataRequest.buildEntitySetContextURL(olingo) method. > Would be nice if we could choose this behavior through a init param in the odata deployment. > Thanks in advance. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5456) Relax scope on methods for EmbeddedServer

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-5456?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-5456. --------------------------------- Fix Version/s: 11.1 (was: 11.x) Resolution: Done > Relax scope on methods for EmbeddedServer > ----------------------------------------- > > Key: TEIID-5456 > URL: https://issues.jboss.org/browse/TEIID-5456 > Project: Teiid > Issue Type: Enhancement > Components: Embedded > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Trivial > Fix For: 11.1 > > > Relax the package private usage of methods to protected for ConnectionProviders and TranslatorRepository -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5457) Issues with sybase/ms sql pad pushdown

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5457?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5457: --------------------------------------- For later AES versions "sql sqlnull on" can be run as an initialization query just like with mysql - http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.... > Issues with sybase/ms sql pad pushdown > -------------------------------------- > > Key: TEIID-5457 > URL: https://issues.jboss.org/browse/TEIID-5457 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 11.1 > > > Sybase will return a non-null result then padding a null string. > Sybase and ms sql will trim from the string from the left when lpad is specified with a pad length shorter than the string. The expected behavior is to always trim from the right. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5457) Issues with sybase/ms sql pad pushdown

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5457: ------------------------------------- Summary: Issues with sybase/ms sql pad pushdown Key: TEIID-5457 URL: https://issues.jboss.org/browse/TEIID-5457 Project: Teiid Issue Type: Bug Components: JDBC Connector Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 11.1 Sybase will return a non-null result then padding a null string. Sybase and ms sql will trim from the string from the left when lpad is specified with a pad length shorter than the string. The expected behavior is to always trim from the right. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5445) Atomic block is ignored when working with execute immediate command

by dalex dalex (JIRA)

[ https://issues.jboss.org/browse/TEIID-5445?page=com.atlassian.jira.plugin... ] dalex dalex commented on TEIID-5445: ------------------------------------ [~shawkins] thx a lot for the quick fix, it worked. > Atomic block is ignored when working with execute immediate command > ------------------------------------------------------------------- > > Key: TEIID-5445 > URL: https://issues.jboss.org/browse/TEIID-5445 > Project: Teiid > Issue Type: Bug > 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: dalex dalex > Assignee: Steven Hawkins > Fix For: 11.1, 10.3.4, 11.0.2 > > > When calling in atomic block a proc which is throwing an exception after updating some rows these changed rows won't be rolled back. That is running the following query: > {code:sql} > begin atomic > call test_upd.upd(); > end ;; > {code} > all changes done in the test_upd.upd virtual procedure won't be rolled back in case of a thrown exception there. If I'm not mistaken such behavior was introduced in scope of TEIID-4504 issue (after introducing the Program.instructionsRequireTransaction method). -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 4 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2018