October 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4492) When using annotations, add option that specifies all child classes to register as part of the JDG schema

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4492?page=com.atlassian.jira.plugin... ] Van Halbert reassigned TEIID-4492: ---------------------------------- Assignee: Van Halbert (was: Steven Hawkins) > When using annotations, add option that specifies all child classes to register as part of the JDG schema > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-4492 > URL: https://issues.jboss.org/browse/TEIID-4492 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 9.2 > Reporter: Van Halbert > Assignee: Van Halbert > > When using protobuf annotations, need to specify all the child related (e.g, 1-to-1 relationship or 1-to-many relationship) pojo's that also need to be registered with the JDG schema. When these are registered, JDG will auto generate the .proto file and marshallers used by the schema. Which is the information used by the hot rod translator to create the source models. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4487) NPE if using multi-value prepared INSERT

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4487?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-4487: ------------------------------------- In my test, I am testing both ways: - using _(?,?),(?,?),..._ construct - here, prepared statement is probably not needed, simple Statement should work as well - using batch (_addBatch ()_ and _executeBatch()_) > NPE if using multi-value prepared INSERT > ---------------------------------------- > > Key: TEIID-4487 > URL: https://issues.jboss.org/browse/TEIID-4487 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 9.1 > > > If user issues multi-value insert, Teiid throws NPE. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4491) Refine uniqueidentifier support for SQL Server

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4491?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4491. ----------------------------------- Resolution: Done Made the use of the cast version dependent. > Refine uniqueidentifier support for SQL Server > ---------------------------------------------- > > Key: TEIID-4491 > URL: https://issues.jboss.org/browse/TEIID-4491 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Connector > Affects Versions: 7.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > SQL Servers later than 2000 can treat uniqueidentifier as a comparable type - there is no need to always cast. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4491) Refine uniqueidentifier support for SQL Server

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4491: ------------------------------------- Summary: Refine uniqueidentifier support for SQL Server Key: TEIID-4491 URL: https://issues.jboss.org/browse/TEIID-4491 Project: Teiid Issue Type: Quality Risk Components: JDBC Connector Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1 SQL Servers later than 2000 can treat uniqueidentifier as a comparable type - there is no need to always cast. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4117) Add explicit empty handling for array values in xmltable

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4117?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4117. ----------------------------------- Fix Version/s: (was: 9.1) Resolution: Rejected While a logical change, this doesn't warrant modifying the already non-standard handling of array types - as it can easily be worked around in the projection above by using ifnull/nvl. > Add explicit empty handling for array values in xmltable > -------------------------------------------------------- > > Key: TEIID-4117 > URL: https://issues.jboss.org/browse/TEIID-4117 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > > Currently we default to null on empty behavior, but it would be good to allow empty on empty as well: > xmltable('/a' passing convert('<a></a>', xml) columns x string[] path 'b') > will produce a null value, but in some cases you'd want to produce an empty array. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3660) Add support for unnesting anti semijoins

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3660?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3660: ---------------------------------- Description: Currently we won't perform the rewrite if it's the anti case. A subquery used as an anti semijoin can be unnested into a left outer join with a filter on the null rows. (was: Currently we won't perform the rewrite if it's the anit case. A subquery used as an anti semijoin can be unnested into a left outer join with a filter on the null rows. ) > Add support for unnesting anti semijoins > ---------------------------------------- > > Key: TEIID-3660 > URL: https://issues.jboss.org/browse/TEIID-3660 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > Currently we won't perform the rewrite if it's the anti case. A subquery used as an anti semijoin can be unnested into a left outer join with a filter on the null rows. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4490) Insert with multiple values doesn't allow subqueries

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4490?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4490: ---------------------------------- Fix Version/s: 9.1 > Insert with multiple values doesn't allow subqueries > ---------------------------------------------------- > > Key: TEIID-4490 > URL: https://issues.jboss.org/browse/TEIID-4490 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > Since multiple values are converted into a union all at parsing time, the validator will not allow subqueries. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4490) Insert with multiple values doesn't allow subqueries

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4490?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4490. ----------------------------------- Resolution: Done Added a check to see if a row value was being used. > Insert with multiple values doesn't allow subqueries > ---------------------------------------------------- > > Key: TEIID-4490 > URL: https://issues.jboss.org/browse/TEIID-4490 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > > Since multiple values are converted into a union all at parsing time, the validator will not allow subqueries. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4490) Insert with multiple values doesn't allow subqueries

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4490: ------------------------------------- Summary: Insert with multiple values doesn't allow subqueries Key: TEIID-4490 URL: https://issues.jboss.org/browse/TEIID-4490 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 8.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Since multiple values are converted into a union all at parsing time, the validator will not allow subqueries. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4487) NPE if using multi-value prepared INSERT

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4487?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4487. ----------------------------------- Resolution: Done Updated the handling in the setquery resolver to not throw an npe and the insert logic to re-resolve so that the expected types are set. > NPE if using multi-value prepared INSERT > ---------------------------------------- > > Key: TEIID-4487 > URL: https://issues.jboss.org/browse/TEIID-4487 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 9.1 > > > If user issues multi-value insert, Teiid throws NPE. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 2 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2016