May 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4191) Add a NOQUOTE option for the TEXTAGG function

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4191?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4191: ---------------------------------- Component/s: Grammar Fix Version/s: 9.1 Targeting at 9.1, unless there is a need to have the enhancement sooner. > Add a NOQUOTE option for the TEXTAGG function > --------------------------------------------- > > Key: TEIID-4191 > URL: https://issues.jboss.org/browse/TEIID-4191 > Project: Teiid > Issue Type: Feature Request > Components: Grammar, Server > Affects Versions: 8.7.5.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.1 > > > Currently on the TEXTAGG function it defaults to double quotes(") and you can specify something else with QUOTE, but there is not a way to have NO QUOTES at all. Can this be added? -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4112) ORA-32039: recursive WITH clause must have column alias list

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4112?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4112: ------------------------------------------------ jolee(a)redhat.com changed the Status of [bug 1322935|https://bugzilla.redhat.com/show_bug.cgi?id=1322935] from ASSIGNED to MODIFIED > ORA-32039: recursive WITH clause must have column alias list > ------------------------------------------------------------ > > Key: TEIID-4112 > URL: https://issues.jboss.org/browse/TEIID-4112 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector, Query Engine > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.7.6.6_2 > > > If running a WITH table AS(...) query to Oracle and the query schema name is the same as the subquery name i.e. EWI. you receive the Oracle error: > ORA-32039: recursive WITH clause must have column alias list > If you modify the query to > WITH EWI1 AS .... > then it works. > f.ex: > breaking: WITH tbl AS ( > where tbl = a common table name in the current schema and the common table definition as (...) references a view in that schema. Oracle will complain with this erroneous error. > work-around: WITH tbl_1 AS( > where tbl_1 does not exist as a current schema/table name. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4206) Validate property setters

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4206?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4206. ----------------------------------- Resolution: Done Added a validation and a readOnly option on the TranslatorProperty annotation. Also corrected setters on the JDBC and Swagger translators. > Validate property setters > ------------------------- > > Key: TEIID-4206 > URL: https://issues.jboss.org/browse/TEIID-4206 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0 > > > If a property setter doesn't exist the property is treated as read only, however this likely indicates an error. We can still allow read only properties, but that needs to be declarative instead. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4112) ORA-32039: recursive WITH clause must have column alias list

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4112?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4112. ----------------------------------- Resolution: Done > ORA-32039: recursive WITH clause must have column alias list > ------------------------------------------------------------ > > Key: TEIID-4112 > URL: https://issues.jboss.org/browse/TEIID-4112 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector, Query Engine > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.7.6.6_2 > > > If running a WITH table AS(...) query to Oracle and the query schema name is the same as the subquery name i.e. EWI. you receive the Oracle error: > ORA-32039: recursive WITH clause must have column alias list > If you modify the query to > WITH EWI1 AS .... > then it works. > f.ex: > breaking: WITH tbl AS ( > where tbl = a common table name in the current schema and the common table definition as (...) references a view in that schema. Oracle will complain with this erroneous error. > work-around: WITH tbl_1 AS( > where tbl_1 does not exist as a current schema/table name. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4206) Validate property setters

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4206: ------------------------------------- Summary: Validate property setters Key: TEIID-4206 URL: https://issues.jboss.org/browse/TEIID-4206 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.0 If a property setter doesn't exist the property is treated as read only, however this likely indicates an error. We can still allow read only properties, but that needs to be declarative instead. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4112) ORA-32039: recursive WITH clause must have column alias list

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4112?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4112: --------------------------------------- Corrected the typo. There may be a tweak needed to the translator property logic as we're assuming that properties without setters are read-only - but that should be a declarative concept, rather than implicit. > ORA-32039: recursive WITH clause must have column alias list > ------------------------------------------------------------ > > Key: TEIID-4112 > URL: https://issues.jboss.org/browse/TEIID-4112 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector, Query Engine > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.7.6.6_2 > > > If running a WITH table AS(...) query to Oracle and the query schema name is the same as the subquery name i.e. EWI. you receive the Oracle error: > ORA-32039: recursive WITH clause must have column alias list > If you modify the query to > WITH EWI1 AS .... > then it works. > f.ex: > breaking: WITH tbl AS ( > where tbl = a common table name in the current schema and the common table definition as (...) references a view in that schema. Oracle will complain with this erroneous error. > work-around: WITH tbl_1 AS( > where tbl_1 does not exist as a current schema/table name. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4205) send results proactively under a cursor as it looks like the ODBC client requires a transaction.

by Debbie Steigner (JIRA)

Debbie Steigner created TEIID-4205: -------------------------------------- Summary: send results proactively under a cursor as it looks like the ODBC client requires a transaction. Key: TEIID-4205 URL: https://issues.jboss.org/browse/TEIID-4205 Project: Teiid Issue Type: Feature Request Components: ODBC, Server Affects Versions: 8.7.5.6_2 Reporter: Debbie Steigner Assignee: Steven Hawkins Currently when querying large resultsets with ODBC the results are not sent as soon as the batch is logically available (like we do for JDBC) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4204) Examples dynamicvdb-restservice - rest client returns always empty body

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4204?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4204: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1334694 Bugzilla Update: Perform > Examples dynamicvdb-restservice - rest client returns always empty body > ------------------------------------------------------------------------ > > Key: TEIID-4204 > URL: https://issues.jboss.org/browse/TEIID-4204 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Affects Versions: 8.12.5 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > > Description of problem: > rest-client returns always empty body for every request like follows: > [jdurani@localhost resteasy-client]$ java -cp target/dependency/*:target/dynamicvdb-resteasy-client.jar org.jboss.teiid.quickstart.PortfolioClient > JAX-RS 2.0 Client API -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4204) Examples dynamicvdb-restservice - rest client returns always empty body

by Van Halbert (JIRA)

Van Halbert created TEIID-4204: ---------------------------------- Summary: Examples dynamicvdb-restservice - rest client returns always empty body Key: TEIID-4204 URL: https://issues.jboss.org/browse/TEIID-4204 Project: Teiid Issue Type: Bug Components: Quick Starts Affects Versions: 8.12.5 Reporter: Van Halbert Assignee: Van Halbert Priority: Minor Description of problem: rest-client returns always empty body for every request like follows: [jdurani@localhost resteasy-client]$ java -cp target/dependency/*:target/dynamicvdb-resteasy-client.jar org.jboss.teiid.quickstart.PortfolioClient JAX-RS 2.0 Client API -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4112) ORA-32039: recursive WITH clause must have column alias list

by Andrej Šmigala (JIRA)

[ https://issues.jboss.org/browse/TEIID-4112?page=com.atlassian.jira.plugin... ] Andrej Šmigala reopened TEIID-4112: ----------------------------------- The setter for the property has a typo in the name [1], so this property cannot be set. [1] https://github.com/teiid/teiid/blob/master/api/src/main/java/org/teiid/tr... > ORA-32039: recursive WITH clause must have column alias list > ------------------------------------------------------------ > > Key: TEIID-4112 > URL: https://issues.jboss.org/browse/TEIID-4112 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector, Query Engine > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.7.6.6_2 > > > If running a WITH table AS(...) query to Oracle and the query schema name is the same as the subquery name i.e. EWI. you receive the Oracle error: > ORA-32039: recursive WITH clause must have column alias list > If you modify the query to > WITH EWI1 AS .... > then it works. > f.ex: > breaking: WITH tbl AS ( > where tbl = a common table name in the current schema and the common table definition as (...) references a view in that schema. Oracle will complain with this erroneous error. > work-around: WITH tbl_1 AS( > where tbl_1 does not exist as a current schema/table name. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2016