September 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3622) HBase translator - INSERT could rewrite the data

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3622?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3622. ----------------------------------- Fix Version/s: 8.12 Resolution: Done Marking as resolved in 8.12 with a doc note. When we support merge statement push down we can revisit disabling insert/update support. > HBase translator - INSERT could rewrite the data > ------------------------------------------------ > > Key: TEIID-3622 > URL: https://issues.jboss.org/browse/TEIID-3622 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Hbase: 1.1.1 > Phoenix: 4.5.0-HBase-1.1 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12 > > > The HBase translator translates INSERT as UPSERT, which is an "alias" for both INSERT and UPDATE statement. It means, if user issues same INSERT statement twice, no exception is thrown [1]. I expect that [2] could rewrite the data. > *Additional note*: I was not able to verify my assumption because of https://issues.jboss.org/browse/TEIID-3619 > [1] > INSERT INTO smalla (intkey) VALUES (55) is translated as UPSERT INTO smalla (intkey) VALUES (55) > http://phoenix.apache.org/language/index.html#upsert_values > [2] > INSERT INTO smalla (intkey, name) VALUES (1, 'name1') > INSERT INTO smalla (intkey, name) VALUES (1, 'name2') -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3671) filter on child table not working

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3671. ----------------------------------- Fix Version/s: 8.11.4 8.12 Resolution: Done Changed the visitation logic so that selectively build the where clause and removed the special handling of predicates in the order by clause. > filter on child table not working > --------------------------------- > > Key: TEIID-3671 > URL: https://issues.jboss.org/browse/TEIID-3671 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Prashanthi Kairuppala > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.11.4, 8.12 > > Attachments: parent_childTables.PNG > > > > Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13. > > Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22' > -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3553) Odata - if table name is ambiguous, teiid returns result from first table

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3553?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3553: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1234724|https://bugzilla.redhat.com/show_bug.cgi?id=1234724] from VERIFIED to ON_QA > Odata - if table name is ambiguous, teiid returns result from first table > ------------------------------------------------------------------------- > > Key: TEIID-3553 > URL: https://issues.jboss.org/browse/TEIID-3553 > Project: Teiid > Issue Type: Quality Risk > Components: OData > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.12 > > > If table name is ambiguous, teiid returns data from first matching table. I expect, that it should return error message similar to exception which is thrown via JDBC. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3553) Odata - if table name is ambiguous, teiid returns result from first table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3553?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3553. ----------------------------------- Resolution: Done Corrected with an additional commit to restore using the nav property entity set. > Odata - if table name is ambiguous, teiid returns result from first table > ------------------------------------------------------------------------- > > Key: TEIID-3553 > URL: https://issues.jboss.org/browse/TEIID-3553 > Project: Teiid > Issue Type: Quality Risk > Components: OData > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.12 > > > If table name is ambiguous, teiid returns data from first matching table. I expect, that it should return error message similar to exception which is thrown via JDBC. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3671) filter on child table not working

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-3671 at 9/2/15 11:31 AM: ---------------------------------------------------------------- Yes there is an issue here. The effect of the filter is removing the effect of the entity key. was (Author: shawkins): Yes there is an issue here. The affect of the filter is removing the affect of the entity key. > filter on child table not working > --------------------------------- > > Key: TEIID-3671 > URL: https://issues.jboss.org/browse/TEIID-3671 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Prashanthi Kairuppala > Assignee: Steven Hawkins > Priority: Critical > Attachments: parent_childTables.PNG > > > > Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13. > > Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22' > -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3671) filter on child table not working

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin... ] Work on TEIID-3671 started by Steven Hawkins. --------------------------------------------- > filter on child table not working > --------------------------------- > > Key: TEIID-3671 > URL: https://issues.jboss.org/browse/TEIID-3671 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Prashanthi Kairuppala > Assignee: Steven Hawkins > Priority: Critical > Attachments: parent_childTables.PNG > > > > Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13. > > Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22' > -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3671) filter on child table not working

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin... ] Steven Hawkins reassigned TEIID-3671: ------------------------------------- Assignee: Steven Hawkins > filter on child table not working > --------------------------------- > > Key: TEIID-3671 > URL: https://issues.jboss.org/browse/TEIID-3671 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Prashanthi Kairuppala > Assignee: Steven Hawkins > Priority: Critical > Attachments: parent_childTables.PNG > > > > Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13. > > Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22' > -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3671) filter on child table not working

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3671: --------------------------------------- Yes there is an issue here. The affect of the filter is removing the affect of the entity key. > filter on child table not working > --------------------------------- > > Key: TEIID-3671 > URL: https://issues.jboss.org/browse/TEIID-3671 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Prashanthi Kairuppala > Priority: Critical > Attachments: parent_childTables.PNG > > > > Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13. > > Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22' > -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3553) Odata - if table name is ambiguous, teiid returns result from first table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3553?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-3553: ----------------------------------- This introduced a regression in fetching nav properties. > Odata - if table name is ambiguous, teiid returns result from first table > ------------------------------------------------------------------------- > > Key: TEIID-3553 > URL: https://issues.jboss.org/browse/TEIID-3553 > Project: Teiid > Issue Type: Quality Risk > Components: OData > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.12 > > > If table name is ambiguous, teiid returns data from first matching table. I expect, that it should return error message similar to exception which is thrown via JDBC. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3671) filter on child table not working

by Prashanthi Kairuppala (JIRA)

[ https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin... ] Prashanthi Kairuppala commented on TEIID-3671: ---------------------------------------------- Hi [~blafond], Please find the below sql statements. For sales table- SELECT OracleConn.SALES_MAN.SM_ID AS ID, OracleConn.SALES_MAN.FIRST_NAME, OracleConn.SALES_MAN.LAST_NAME FROM OracleConn.SALES_MAN For sales_uk table- SELECT OracleConn.UK_SALE.SALE_ID, OracleConn.UK_SALE.DISCOUNT, OracleConn.UK_SALE.TYPE, OracleConn.UK_SALE.PRICE, OracleConn.UK_SALE.SM_ID AS ID FROM OracleConn.UK_SALE Thanks, Prashanthi. > filter on child table not working > --------------------------------- > > Key: TEIID-3671 > URL: https://issues.jboss.org/browse/TEIID-3671 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Prashanthi Kairuppala > Priority: Critical > Attachments: parent_childTables.PNG > > > > Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13. > > Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22' > -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2015