June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4237) INNER JOIN returns incorrect results

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4237?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4237. --------------------------------- > INNER JOIN returns incorrect results > ------------------------------------ > > Key: TEIID-4237 > URL: https://issues.jboss.org/browse/TEIID-4237 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.7.6, 8.12.5, 8.7.7.6_2, 8.13.5 > > > Running the following query: > {code:sql} > select avg(t1.a) from > (select 3 as a, 3 as b union all > select 1 as a, 1 as b union all > select 3 as a, 3 as b) as t1 > join (select 1 as a, 1 as b union all > select 1 as a, 1 as b union all > select 2 as a, 2 as b union all > select 2 as a, 2 as b union all > select 3 as a, 3 as b union all > select 3 as a, 3 as b) as t2 on t1.a=t2.a > {code} > on teiid causes incorrect result: 2 in comparing with mysql which returns 2.333. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4273) With clause used in evaluatable subquery in a fully pushed user query is seen as missing temp table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4273?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4273. --------------------------------- > With clause used in evaluatable subquery in a fully pushed user query is seen as missing temp table > --------------------------------------------------------------------------------------------------- > > Key: TEIID-4273 > URL: https://issues.jboss.org/browse/TEIID-4273 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 8.12.5, 8.7.7.6_2, 9.0.1 > > > A query such as: > WITH qry_0 as /\*+ no_inline */ (SELECT e2 AS a1, e1 as str FROM pm1.g1 AS t), qry_1 as /\*+ no_inline */ (SELECT 'b' AS a1) select (select a1 || 'a' from qry_1) as x, a1 from qry_0 > where the projected scalar subquery cannot be pushed down, but the rest of the query can will result in the with plan for qry_1 not being associated with the parent RelationalPlan and results in an exception that the temporary table cannot be found. This does not occur if the clause is inlined (9.0+). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4262) Wrong result (empty or NULL) with an view and a single disjunction for join criteria

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4262?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4262. --------------------------------- > Wrong result (empty or NULL) with an view and a single disjunction for join criteria > ------------------------------------------------------------------------------------ > > Key: TEIID-4262 > URL: https://issues.jboss.org/browse/TEIID-4262 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.0 > Reporter: Salvatore R > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.12.5, 8.7.7.6_2, 8.13.6 > > > The following query returns an empty result instead of 1: > {code:sql} > SELECT alias3.a1 FROM (select 1 as a) as alias2 INNER JOIN (SELECT t2.a AS a1, t1.a FROM (SELECT 1 AS a) AS t1 INNER JOIN (select 1 as a) as t2 ON t1.a = t2.a) AS alias3 ON ((alias3.a = alias2.a) OR (alias3.a > alias2.a)) > {code} > when updating the parent join on removing the alias3 view layer, the OR condition is being converted to AND - which can never be true. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4200) Provide support for Wildfly 10

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4200?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4200: ------------------------------------ There's 3 reasons; 1) ease for the user to find and change (i.e., web.xml) 2) patching and 3) deployment in domain mode > Provide support for Wildfly 10 > ------------------------------ > > Key: TEIID-4200 > URL: https://issues.jboss.org/browse/TEIID-4200 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Blocker > Fix For: 9.1 > > > Upgrade the host runtime environment for Teiid Server to be WildFly 10. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4200) Provide support for Wildfly 10

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4200?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4200: ------------------------------------- [~van.halbert] What was reason in product to move these from modules directory to a seperate directory? I trying to see if there is better way to do this? I like to preserve the automatic deployment for the community version if possible, that saves one extra manual step user needs to do. > Provide support for Wildfly 10 > ------------------------------ > > Key: TEIID-4200 > URL: https://issues.jboss.org/browse/TEIID-4200 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Blocker > Fix For: 9.1 > > > Upgrade the host runtime environment for Teiid Server to be WildFly 10. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3686) OData DELETE nonexisting row - wrong response code

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3686?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3686: ------------------------------------- [~van.halbert] Ok, pulled the code into 63-8.12.x > OData DELETE nonexisting row - wrong response code > -------------------------------------------------- > > Key: TEIID-3686 > URL: https://issues.jboss.org/browse/TEIID-3686 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7.1.6_2 > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Labels: CR1 > Fix For: 8.12, 8.7.2.6_2 > > > I deployed VDB that can be accessed with OData. When I perform DELETE request to remove row for first time response code is 200 OK (maybe it should be 204) but when I repeat the same DELETE request and tried to delete already deleted entry, response is again 200 OK, but it should be 404 Not Found. Same thing happens even I when tried to delete entry with id that doesn't exist at all. > Only indication of this problem is in the server log: > {code:plain}INFO [org.teiid.ODATA] (http-/127.0.0.1:8080-1) no entity to delete in = BooksMySQL.BOOKS with key= ('1') > {code} > I think that response code for deleting row that doesn't exist should be different than 200 OK. > For example the service at odata.org returns following content with response code 404 Not Found: > {code:xml} > <?xml version="1.0" encoding="utf-8" standalone="yes"?> > <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"> > <code></code> > <message xml:lang="en-US">Resource not found for the segment 'Products'.</message> > </error> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4288) Cancel method against a socket based jdbc query can wait for synch timeout

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4288?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4288: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1350333 Bugzilla Update: Perform > Cancel method against a socket based jdbc query can wait for synch timeout > -------------------------------------------------------------------------- > > Key: TEIID-4288 > URL: https://issues.jboss.org/browse/TEIID-4288 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.1 > > > If a JDBC socket query is cancelled using a separate thread, the cancel call may wait until the timeout due to being synchronized which prevents the main execution thread from processing it's response. > Details were also added to TEIID-3781 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4300) Soft dead lock between the main reader thread and the cancel thread

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4300?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4300. ----------------------------------- Resolution: Duplicate Duplicate of TEIID-4288 > Soft dead lock between the main reader thread and the cancel thread > ------------------------------------------------------------------- > > Key: TEIID-4300 > URL: https://issues.jboss.org/browse/TEIID-4300 > Project: Teiid > Issue Type: Bug > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > From Steven's [comment|https://issues.jboss.org/browse/TEIID-3781?focusedCommentId=13255...]: > {quote} > I can see on the client side that there is a soft dead lock between the main reader thread and the cancel thread, such that the synchronization of the cancel method can prevent it from receiving the response. > {quote} > You can find logs and description [here|https://issues.jboss.org/browse/TEIID-3781?focusedCommentId=13254934...]. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4200) Provide support for Wildfly 10

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4200?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4200: ------------------------------------ Can the war artifacts be moved to teiid supplied folder and change the install cli script to install based on relative location. Similar to this: /deployment=teiid-odata.war:add(runtime-name=teiid-odata.war,content=[{path=dataVirtualization/vdb/teiid-odata.war/,archive=false,relative-to=jboss.home.dir}],enabled=true) /deployment=teiid-olingo-odata4.war:add(runtime-name=teiid-olingo-odata4.war,content=[{path=dataVirtualization/vdb/teiid-olingo-odata4.war/,archive=false,relative-to=jboss.home.dir}],enabled=true) > Provide support for Wildfly 10 > ------------------------------ > > Key: TEIID-4200 > URL: https://issues.jboss.org/browse/TEIID-4200 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Blocker > Fix For: 9.1 > > > Upgrade the host runtime environment for Teiid Server to be WildFly 10. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4297) Add UDF functions based on OSDQ for POC

by JieRen JieRen (JIRA)

[ https://issues.jboss.org/browse/TEIID-4297?page=com.atlassian.jira.plugin... ] JieRen JieRen edited comment on TEIID-4297 at 6/27/16 6:34 AM: --------------------------------------------------------------- Hi Ramesh: I am not sure whether I understand this task . I would like to show my steps that you can check whether I am correct. * Create Maskutil class Create Maskutil class as above * Install Module Build Maskutil ,Install Maskutil module * Define virtual function Define virtual function in VDB deploy file. ---- <model name="VituralFunction" type="VIRTUAL"> <metadata type="DDL"><![CDATA[ CREATE VIRTUAL FUNCTION random(className string) RETURNS string OPTIONS (JAVA_CLASS 'org.teiid.Maskutil', JAVA_METHOD 'toRandomValue'); CREATE VIRTUAL FUNCTION hash(className string) RETURNS string OPTIONS (JAVA_CLASS 'org.teiid.Maskutil', JAVA_METHOD 'toHashValue'); CREATE VIRTUAL FUNCTION digit(className string) RETURNS string OPTIONS (JAVA_CLASS 'org.teiid.Maskutil', JAVA_METHOD 'toDigitValue'); ]]> </metadata> </model> ---- * Test UDF ~~~ mvn -s ../settings.xml exec:java -Dvdb="Portfolio" -Dsql="select * from product where symbol=hash()" -Dusername="odataUser" -Dpassword="password1!" ~~~ That's all. If I don't get your point, please forgive me and describe this issue in detail. Thank you a lot. was (Author: jren): Hi Ramesh: I am not sure whether I understand this task . I would like to show my steps that you can check whether I am correct. * Create Maskutil class Create Maskutil class as above * Install Module Build Maskutil ,Install Maskutil module * Define virtual function Define virtual function in VDB deploy file. ~~~ <model name="VituralFunction" type="VIRTUAL"> <metadata type="DDL"><![CDATA[ CREATE VIRTUAL FUNCTION random(className string) RETURNS string OPTIONS (JAVA_CLASS 'org.teiid.Maskutil', JAVA_METHOD 'toRandomValue'); CREATE VIRTUAL FUNCTION hash(className string) RETURNS string OPTIONS (JAVA_CLASS 'org.teiid.Maskutil', JAVA_METHOD 'toHashValue'); CREATE VIRTUAL FUNCTION digit(className string) RETURNS string OPTIONS (JAVA_CLASS 'org.teiid.Maskutil', JAVA_METHOD 'toDigitValue'); ]]> </metadata> </model> ~~~ * Test UDF ~~~ mvn -s ../settings.xml exec:java -Dvdb="Portfolio" -Dsql="select * from product where symbol=hash()" -Dusername="odataUser" -Dpassword="password1!" ~~~ That's all. If I don't get your point, please forgive me and describe this issue in detail. Thank you a lot. > Add UDF functions based on OSDQ for POC > --------------------------------------- > > Key: TEIID-4297 > URL: https://issues.jboss.org/browse/TEIID-4297 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Ramesh Reddy > Assignee: JieRen JieRen > Fix For: 9.1 > > > Please add following UDF functions to Teiid library based on maven module > http://search.maven.org/#search%7Cga%7C1%7Carrahtec > The UDF functions needs to from this class below > {code} > public class Maskutil { > /** > * @param a > * The string that need to randomize > * vivek singh' will become 'ihg vkeivh' > */ > public static String toRandomValue(String a) { > return ShuffleRTM.shuffleString(a); > } > /** > * @param a > * This function will retrun MD5 hashcode of the string > * @return String > */ > public static String toHashValue(String a) { > if (a == null) > return "d41d8cd98f00b204e9800998ecf8427e"; // null MD5 value > return ResultsetToRTM.getMD5(a).toString(); > } > /** > * @param a > * This function will return digit characters of the string > * @return > * > */ > public static String toDigitValue(String a) { > return StringCaseFormatUtil.digitString(a); > } > } > {code} > for example Teiid should have UDF functions like > {code} > string random(string) > string hash(string) > string digit(string) > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2016