June 2019 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5773) Allow for generated_key retrieval at a session level

by Steven Hawkins (Jira)

Steven Hawkins created TEIID-5773: ------------------------------------- Summary: Allow for generated_key retrieval at a session level Key: TEIID-5773 URL: https://issues.jboss.org/browse/TEIID-5773 Project: Teiid Issue Type: Sub-task Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 12.3 The docs suggest that generated_key should be called in a procedure. However calling outside of a procedure will currently return no values as the keys are associated with the executing command context only. Ideally from a connection the user should be able to do: insert into ...; select generated_key() ...; In separate statements and still retrieve the key value. The workaround is to use an anonymous procedure block: begin insert into ...; select generated_key() ...; end -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5763) GENERATED_KEY returns NULL if used in INSTEAD OF INSERT Triggers in DDL files

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5763?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5763: ---------------------------------- Fix Version/s: 12.3 Priority: Critical (was: Blocker) Marking complete for issues highlighted as 1/3 - where 1 required a code change to always fetch generated keys, and 3 was largely a doc issue. Also added a more convenient generated_keys function and updated the docs with that. > GENERATED_KEY returns NULL if used in INSTEAD OF INSERT Triggers in DDL files > ----------------------------------------------------------------------------- > > Key: TEIID-5763 > URL: https://issues.jboss.org/browse/TEIID-5763 > Project: Teiid > Issue Type: Bug > Affects Versions: 12.2 > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Critical > Fix For: 12.3 > > > The issue arrised in: > https://developer.jboss.org/message/989700#989700 > Following sceanarios are given: > Variant 1: > Table Product(id), primary key = autoincrement; > Table QuicklyAddedProduct, primary key is foreign key on Product.id > Table Diary_SRC > View Diary on Diary_SRC > INSTEAD OF INSERT Trigger on Diary should : > -create new record on Product, > -get autoincremented Product.id of new record, > - create new QuicklyAddedProduct with returned Product.id as primary key > - create new Diary record with QuicklyAddedProduct > { > INSERT a new record on Product; > idProduct = CONVERT(GENERATED_KEY('idProduct'),long); // fails > } > Variant 2: > INSTEAD OF INSERT trigger on Diary should : > - create new QuicklyAddedProduct > - add Quickly added prodcut to Diary > additionally a INSTEAD OF trigger on QuicklyAddedProduct exists which: > - creates new Product record > - uses returned GENERATED_KEY(Product.id) to add record on QuicklyAddedProduct with Product.id as primary key -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5740) Create tables/procedures for query plans and vdb info

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5740?page=com.atlassian.jira.plugin... ] Work on TEIID-5740 started by Steven Hawkins. --------------------------------------------- > Create tables/procedures for query plans and vdb info > ----------------------------------------------------- > > Key: TEIID-5740 > URL: https://issues.jboss.org/browse/TEIID-5740 > Project: Teiid > Issue Type: Sub-task > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.3 > > > We need another mechanism for viewing plans - either a procedure or a table. We also have a lot of vdb information that is not exposed via system metadata. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4251) Built in support for Postgres DB as materialization target

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-4251?page=com.atlassian.jira.plugin... ] Work on TEIID-4251 started by Steven Hawkins. --------------------------------------------- > Built in support for Postgres DB as materialization target > ---------------------------------------------------------- > > Key: TEIID-4251 > URL: https://issues.jboss.org/browse/TEIID-4251 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.3 > > > If Postgres database is available along with install or assumed that it is available, then some of the materialization task can be automated, like > - Creation of a common STATUS table > - Creation of the materilization targets (create views on dbms) > - On load, on undeploy and load scripts for all the materialization views > We need to device a way this to be pluggable, such that based on success of this, we can provide additional support for other sources. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5495) Add support for graphql sources

by Van Halbert (Jira)

[ https://issues.jboss.org/browse/TEIID-5495?page=com.atlassian.jira.plugin... ] Van Halbert reassigned TEIID-5495: ---------------------------------- Assignee: (was: Van Halbert) > Add support for graphql sources > ------------------------------- > > Key: TEIID-5495 > URL: https://issues.jboss.org/browse/TEIID-5495 > Project: Teiid > Issue Type: Feature Request > Components: Connector API > Reporter: Steven Hawkins > Priority: Major > Fix For: 12.3 > > > We should create translator support for graphql, which will also help us evaluate supporting graphql as a front end as well. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5772) Issues with binary/streaming values in odata

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5772?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5772. ----------------------------------- Resolution: Done Corrected the hasStream method and adding handling for BinaryType. > Issues with binary/streaming values in odata > -------------------------------------------- > > Key: TEIID-5772 > URL: https://issues.jboss.org/browse/TEIID-5772 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.3 > > > There are two issues: > 1. The hasStream method always returned false. > 2. There wasn't proper handling for BinaryType in outputting values. The java serialized value, not the simple byte value was presented. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5772) Issues with binary/streaming values in odata

by Steven Hawkins (Jira)

Steven Hawkins created TEIID-5772: ------------------------------------- Summary: Issues with binary/streaming values in odata Key: TEIID-5772 URL: https://issues.jboss.org/browse/TEIID-5772 Project: Teiid Issue Type: Bug Components: OData Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 12.3 There are two issues: 1. The hasStream method always returned false. 2. There wasn't proper handling for BinaryType in outputting values. The java serialized value, not the simple byte value was presented. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-108) Add support for swagger/openapi sources

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-108?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIIDSB-108: ---------------------------------------- So then this would just be to add support for the openapi translator only. > Add support for swagger/openapi sources > --------------------------------------- > > Key: TEIIDSB-108 > URL: https://issues.jboss.org/browse/TEIIDSB-108 > Project: Teiid Spring Boot > Issue Type: Feature Request > Reporter: Steven Hawkins > Priority: Major > Fix For: 1.3.0 > > > There should be source support for swagger/openapi. If we don't want swagger 1 support, then this can just add support for the openapi translator. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

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

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5704?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5704. ----------------------------------- Resolution: Done Updated the docs, added wildfly support and an arquillian test (using odata openapi v2/v3 metadata). > 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 > Priority: Major > Fix For: 12.3 > > > 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)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-108) Add support for swagger/openapi sources

by Ramesh Reddy (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-108?page=com.atlassian.jira.plugi... ] Ramesh Reddy commented on TEIIDSB-108: -------------------------------------- IMO I do not think we need to support those explicitly, generic web service support will handle as a catch-all. > Add support for swagger/openapi sources > --------------------------------------- > > Key: TEIIDSB-108 > URL: https://issues.jboss.org/browse/TEIIDSB-108 > Project: Teiid Spring Boot > Issue Type: Feature Request > Reporter: Steven Hawkins > Priority: Major > Fix For: 1.3.0 > > > There should be source support for swagger/openapi. If we don't want swagger 1 support, then this can just add support for the openapi translator. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2019