July 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5397) RETURN_GENERATED_KEYS not working

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5397?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-5397: ----------------------------------- Reopening to cover adding or inferring primary key information for views. > RETURN_GENERATED_KEYS not working > --------------------------------- > > Key: TEIID-5397 > URL: https://issues.jboss.org/browse/TEIID-5397 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 10.2.1 > Reporter: Lukáš Svačina > Assignee: Steven Hawkins > > *+VDB:+* > {code} > <vdb name="_GENERATED_form_shoes" version="2"> > <model name="_INTERNAL_internalModel" type="PHYSICAL"> > <source name="internal_postgresql" translator-name="postgresql" connection-jndi-name="java:/internal"/> > </model> > <model name="GEN_view" type="VIRTUAL"> > <metadata type="DDL"> > <![CDATA[ CREATE VIEW "_view_workflow_data" OPTIONS (UPDATABLE 'true') > AS SELECT "public"."form_shoes_2"."size" AS "size", "public"."form_shoes_2"."model" AS "model", > "public"."form_shoes_2"."id" AS "id" FROM "public"."form_shoes_2" ]]> > </metadata> > </model> > </vdb> > {code} > *+TABLE:+* > name: form_shoes_2 > columns: id (SERIAL) | size (INTEGER *NULLABLE*) | model (VARCHAR *NULLABLE*) > *+PROBLEM:+* > Connected into VDB using JDBC like: > {code:java} > final PreparedStatement statement = c.prepareStatement(...INSERT..., Statement.RETURN_GENERATED_KEYS); > statement.executeUpdate(); > final ResultSet generatedKeys = statement.getGeneratedKeys(); > {code} > *generatedKeys is empty if:* > # INSERT INTO "form_shoes_2" ( "model" ) VALUES ( 'adidas x1' ) ...... e.g. not all columns are enumerated ... if so, you can provide NULL values to optional columns and generated keys WORK! > # INSERT INTO "_view_workflow_data" (id, name, size) VALUES (42, 'adidas x2', 12 ) ....... e.g. insering into view (1:1, no joins involved) even when all columns ARE enumerated ... probably no way how to get generated keys here? > *+QUESTIONS:+* > # How to get last_insert_id() when inserting into foreign table/views (with/without joins)? > # How to get updated rows (UPDATE ... RETURNING *)? At least primary keys of affected rows? > Thanks for fixing/adding this functionality. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5420) Costing can over estimate join cardinality when no keys nor ndv is specified

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5420: ------------------------------------- Summary: Costing can over estimate join cardinality when no keys nor ndv is specified Key: TEIID-5420 URL: https://issues.jboss.org/browse/TEIID-5420 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 11.1 The changes from TEIID-4485 allow for joins lacking all but cardinality information to have their cardinality over-estimated. The estimate should be made more cautious by default as that would be the most common case. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5419) timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5419?page=com.atlassian.jira.plugin... ] Work on TEIID-5419 started by Steven Hawkins. --------------------------------------------- > timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327 > -------------------------------------------------------------------- > > Key: TEIID-5419 > URL: https://issues.jboss.org/browse/TEIID-5419 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 10.3 > Environment: WFLYSRV0049: WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) > Reporter: Ivan Semenov > Assignee: Steven Hawkins > Fix For: 11.1 > > > After adding support for timestampadd() pushdown to Oracle in TEIID-5327 - Oracle is throwing errors for some pushed queries -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5419) timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5419?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5419: ---------------------------------- Fix Version/s: 11.1 > timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327 > -------------------------------------------------------------------- > > Key: TEIID-5419 > URL: https://issues.jboss.org/browse/TEIID-5419 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 10.3 > Environment: WFLYSRV0049: WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) > Reporter: Ivan Semenov > Assignee: Steven Hawkins > Fix For: 11.1 > > > After adding support for timestampadd() pushdown to Oracle in TEIID-5327 - Oracle is throwing errors for some pushed queries -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5419) timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327

by Ivan Semenov (JIRA)

Ivan Semenov created TEIID-5419: ----------------------------------- Summary: timestampadd(SQL_TSI_QUARTER, 2, date) not working after TEIID-5327 Key: TEIID-5419 URL: https://issues.jboss.org/browse/TEIID-5419 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 10.3 Environment: WFLYSRV0049: WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) Reporter: Ivan Semenov Assignee: Steven Hawkins After adding support for timestampadd() pushdown to Oracle in TEIID-5327 - Oracle is throwing errors for some pushed queries -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5417) Performance degradation with large in predicate against temp table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5417?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5417. ----------------------------------- Resolution: Done Corrected the set creation by the dependent criteria processor and addressed several of the array typing issues that arose. > Performance degradation with large in predicate against temp table > ------------------------------------------------------------------ > > Key: TEIID-5417 > URL: https://issues.jboss.org/browse/TEIID-5417 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 11.1, 11.0.1, 10.3.3 > > > Dependent joins producing a large in predicate will do a linear search over the predicate. The predicate should be marked as all constants and dealt with as a set instead. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5418) Dependent joins should be more selectively against temp tables

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5418: ------------------------------------- Summary: Dependent joins should be more selectively against temp tables Key: TEIID-5418 URL: https://issues.jboss.org/browse/TEIID-5418 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 11.1, 11.0.1 Unless there are intervening nodes a dependent join against a temp table without an index may create a slower running plan than if the dependent join is not used. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5417) Performance degradation with large in predicate against temp table

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5417: ------------------------------------- Summary: Performance degradation with large in predicate against temp table Key: TEIID-5417 URL: https://issues.jboss.org/browse/TEIID-5417 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 11.1, 11.0.1, 10.3.3 Dependent joins producing a large in predicate will do a linear search over the predicate. The predicate should be marked as all constants and dealt with as a set instead. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4757) Support Postgres OLEDB driver for Teiid

by Craig Carpenter (JIRA)

[ https://issues.jboss.org/browse/TEIID-4757?page=com.atlassian.jira.plugin... ] Craig Carpenter edited comment on TEIID-4757 at 7/13/18 8:44 AM: ----------------------------------------------------------------- Is there any other options known to support windows integrated security using ODBC driver that would be a workaround? npgsql OLEDB is not compatible with PostGreSQL 9.0.6. Or any guidance available for connecting to Teiid via ODBC integrated security = true (windows)? was (Author: craigcarpenter): Is there any other options known to support windows integrated security using ODBC driver that would be a workaround? Npgl OLEDB is not compatible with PostGreSQL 9.0.6. Or any guidance available for connecting to Teiid via ODBC integrated security = true (windows)? > Support Postgres OLEDB driver for Teiid > --------------------------------------- > > Key: TEIID-4757 > URL: https://issues.jboss.org/browse/TEIID-4757 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Ramesh Reddy > Priority: Minor > Fix For: Open To Community > > > Provide support for Postgres OLEDB driver to connect to Teiid in issuing the queries. This will help .NET applications to be written to the Teiid. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4757) Support Postgres OLEDB driver for Teiid

by Craig Carpenter (JIRA)

[ https://issues.jboss.org/browse/TEIID-4757?page=com.atlassian.jira.plugin... ] Craig Carpenter commented on TEIID-4757: ---------------------------------------- Is there any other options known to support windows integrated security using ODBC driver that would be a workaround? Npgl OLEDB is not compatible with PostGreSQL 9.0.6. Or any guidance available for connecting to Teiid via ODBC integrated security = true (windows)? > Support Postgres OLEDB driver for Teiid > --------------------------------------- > > Key: TEIID-4757 > URL: https://issues.jboss.org/browse/TEIID-4757 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Ramesh Reddy > Priority: Minor > Fix For: Open To Community > > > Provide support for Postgres OLEDB driver to connect to Teiid in issuing the queries. This will help .NET applications to be written to the Teiid. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 5 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2018