August 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4238) Remove need for quotes around cursor name declarations/fetches

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4238?page=com.atlassian.jira.plugin... ] Johnathon Lee reopened TEIID-4238: ---------------------------------- > Remove need for quotes around cursor name declarations/fetches > -------------------------------------------------------------- > > Key: TEIID-4238 > URL: https://issues.jboss.org/browse/TEIID-4238 > Project: Teiid > Issue Type: Enhancement > Components: ODBC > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2 > > > Attempting to declare a cursor without quotes results in an error similar to[1]. The quotes should be optional except in special cases, as this seems to match later standards (SQL2003). Performing fetch operations against the cursor have the same issue, where if the cursorname is not quoted, parsing errors occur. > [1] Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]DECLARE[*] cursorname CURSOR" at line 1, column 1. > Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4392) Expand star support

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4392: ------------------------------------- Summary: Expand star support Key: TEIID-4392 URL: https://issues.jboss.org/browse/TEIID-4392 Project: Teiid Issue Type: Sub-task Components: OData Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1 The * construct will currently produce a null pointer exception. It should be supported if possible. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4390) Expand level support

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4390?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4390: ---------------------------------- Summary: Expand level support (was: All expand level support) > Expand level support > -------------------- > > Key: TEIID-4390 > URL: https://issues.jboss.org/browse/TEIID-4390 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > We should support the level construct for expand to support recursive relationships. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3177) Enforce SSL connections over ODBC when Encryption Mode is enabled

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3177?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3177: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1312455|https://bugzilla.redhat.com/show_bug.cgi?id=1312455] from VERIFIED to CLOSED > Enforce SSL connections over ODBC when Encryption Mode is enabled > ----------------------------------------------------------------- > > Key: TEIID-3177 > URL: https://issues.jboss.org/browse/TEIID-3177 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Affects Versions: 8.8 > Reporter: Cristiano Nicolai > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.9, 8.7.5.6_2 > > > When connecting via ODBC transport, even if the encryption mode is set to enabled is still possible to establish non ssl connections. This allows clients to connect via insecure method. We would like that the Teiid transport could reject connections if they are not properly set up using SSL transport. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4391) NONDETERMINISTIC functions incorrectly optimized out of ORDER BY

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4391?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4391. ----------------------------------- Fix Version/s: 9.1 9.0.3 Resolution: Done Corrected the evaluatable check for non-determinism. > NONDETERMINISTIC functions incorrectly optimized out of ORDER BY > ---------------------------------------------------------------- > > Key: TEIID-4391 > URL: https://issues.jboss.org/browse/TEIID-4391 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.13.2 > Reporter: Dave Nicodemus > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.3 > > > The default for functions is to be deterministic, so without an argument only a single value is assumed and these functions are optimized out of ORDER BY clauses. > We should be able to change this behavior by marking a function and NON-DETERMINISTIC in the VDB definition like this : > CREATE FOREIGN FUNCTION F() RETURNS FLOAT OPTIONS (NAMEINSOURCE '"app1".F', DETERMINISM 'NONDETERMINISTIC'); > But doing this fails to prevent the function call from being optimized out of the ORDER BY. > Work arounds are to use the function in an expression that involves a table column or add a no-op parameter to the function and pass a table column. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2578) add/remove schema elements

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2578?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2578: ------------------------------------- The following small correction to creation of DATA WRAPPER, adding the TYPE to support override translator types. {code} CREATE FOREIGN ( DATA WRAPPER | TRANSLATOR ) <translator-name> [ TYPE <base-translator-type> ] OPTIONS (...) {code} > add/remove schema elements > -------------------------- > > Key: TEIID-2578 > URL: https://issues.jboss.org/browse/TEIID-2578 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 9.1 > > > Schemas are currently static after load. Modifications can only happen with restarts or new versions. We should allow add/drop at runtime. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4002) Configuring of JDG DSL resource adapter still requires marshaller and protobuf when using annotations to define schema

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4002?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4002: --------------------------------- Fix Version/s: 8.12 > Configuring of JDG DSL resource adapter still requires marshaller and protobuf when using annotations to define schema > ---------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-4002 > URL: https://issues.jboss.org/browse/TEIID-4002 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.x > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Blocker > Fix For: 8.12, 9.0, 8.12.5 > > > To improve the usability of JDG as a materialized data source, the resource-adapter needs to be changed to not require the marshaller/protobuf file when the the pojo class has the defined annotations for specifying the schema. > Currently, the marshaller(s) and protobuf are required. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4391) NONDETERMINISTIC functions incorrectly optimized out of ORDER BY

by Dave Nicodemus (JIRA)

Dave Nicodemus created TEIID-4391: ------------------------------------- Summary: NONDETERMINISTIC functions incorrectly optimized out of ORDER BY Key: TEIID-4391 URL: https://issues.jboss.org/browse/TEIID-4391 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 8.13.2 Reporter: Dave Nicodemus Assignee: Steven Hawkins The default for functions is to be deterministic, so without an argument only a single value is assumed and these functions are optimized out of ORDER BY clauses. We should be able to change this behavior by marking a function and NON-DETERMINISTIC in the VDB definition like this : CREATE FOREIGN FUNCTION F() RETURNS FLOAT OPTIONS (NAMEINSOURCE '"app1".F', DETERMINISM 'NONDETERMINISTIC'); But doing this fails to prevent the function call from being optimized out of the ORDER BY. Work arounds are to use the function in an expression that involves a table column or add a no-op parameter to the function and pass a table column. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4323) Add support for first/last/absolute/relative "FETCH " syntax

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4323?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4323: ------------------------------------------------ jolee(a)redhat.com changed the Status of [bug 1353933|https://bugzilla.redhat.com/show_bug.cgi?id=1353933] from NEW to ASSIGNED > Add support for first/last/absolute/relative "FETCH " syntax > ------------------------------------------------------------ > > Key: TEIID-4323 > URL: https://issues.jboss.org/browse/TEIID-4323 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2 > > > Add Support for the below FETCH syntax: > FETCH LAST FROM cursor_name > FETCH ABSOLUTE fetch_when FROM cursor_name > FETCH RELATIVE fetch_when FROM cursor_name > FETCH FIRST FROM cursor_name -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4278) MySQL 5 should support distinct aggregates

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4278?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4278: ------------------------------------------------ jolee(a)redhat.com changed the Status of [bug 1349562|https://bugzilla.redhat.com/show_bug.cgi?id=1349562] from NEW to ASSIGNED > MySQL 5 should support distinct aggregates > ------------------------------------------ > > Key: TEIID-4278 > URL: https://issues.jboss.org/browse/TEIID-4278 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2 > > > Older versions of mysql only supported distinct count, but later versions supported distinct with all relevant aggregates. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2016