July 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3545) Improvements in default handling

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3545?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3545: --------------------------------------- Using the default keyword will require either significant parsing changes or a good bit of validation to ensure the expression is not used in other contexts. Also adding support for DEFAULT VALUES seems low priority as it would not be often used. That leaves: - allowing the default value to be a Teiid expression (this may require extension metadata for backwards compatibility and some sources use special values) - allowing the source query to use the source default, rather than using a default specified in Teiid. This will also likely require extension metadata and/or an import option to not set the default value. > Improvements in default handling > -------------------------------- > > Key: TEIID-3545 > URL: https://issues.jboss.org/browse/TEIID-3545 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors, Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12 > > > The current default field is just a string value and captured as a string value at import time - in general it should be allowed to be an expression. Also our insert syntax should support the default/defaults keywords and be able to propagate that to the source, rather than using the default on the model. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3502) Teiid returns integer/long overflow values

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3502?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3502. ----------------------------------- Resolution: Done Updated to detect overflow for precision as well. > Teiid returns integer/long overflow values > ------------------------------------------ > > Key: TEIID-3502 > URL: https://issues.jboss.org/browse/TEIID-3502 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12, 8.11.1 > > > The values from basic math operations, such as: > SELECT abs(-2147483648) > SELECT -2147483648 -1 > SELECT 2147483648 +1 > etc. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3177?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3177. --------------------------------- > 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 > > > 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.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2243) Add ability to configure (change default) support for nulls first/last

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2243?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2243. --------------------------------- > Add ability to configure (change default) support for nulls first/last > ---------------------------------------------------------------------- > > Key: TEIID-2243 > URL: https://issues.jboss.org/browse/TEIID-2243 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 7.4.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Optional > Fix For: 8.10 > > > Add the ability to configure how nulls first/last will be handled. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2913) Remove Logging Quickstart

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2913?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2913. --------------------------------- > Remove Logging Quickstart > ------------------------- > > Key: TEIID-2913 > URL: https://issues.jboss.org/browse/TEIID-2913 > Project: Teiid > Issue Type: Task > Components: Quick Starts > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > > Add the following enhancements to the logging quick start: > - add example for audit logging to a database (use h2) > - add dynamic VDB's to expose the audit and command logging schemas > - add a preconfigured dashboard to present the audit and command logs -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3149) External materialization management with Embedded Server

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3149?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3149. --------------------------------- > External materialization management with Embedded Server > -------------------------------------------------------- > > Key: TEIID-3149 > URL: https://issues.jboss.org/browse/TEIID-3149 > Project: Teiid > Issue Type: Enhancement > Components: Embedded > Reporter: Joseph CHIDIAC > Assignee: Ramesh Reddy > Labels: External, beta2, materialization > Fix For: 8.9 > > > External materialization management is currently only enabled for the AS server environment. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3053) Detect when returnable procedure results need to be processed in the procedure

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3053?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3053. --------------------------------- > Detect when returnable procedure results need to be processed in the procedure > ------------------------------------------------------------------------------ > > Key: TEIID-3053 > URL: https://issues.jboss.org/browse/TEIID-3053 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 8.9 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > With TEIID-3052 we are now fully processing almost all results in the originating procedure scope whereas before we were effective performing pipelining in that the results were created off of the tuple source on demand. > With some upfront or processing time detection we could see when the processorplan is relying upon resources from the program scope and if not go ahead and pop/return the results as before. We could also develop a better strategy for dealing with the case when resources are needed. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3116) Teiid Partial Results Mode: unavailability of datasource causes error (which is not masked)

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3116?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3116. --------------------------------- > Teiid Partial Results Mode: unavailability of datasource causes error (which is not masked) > ------------------------------------------------------------------------------------------- > > Key: TEIID-3116 > URL: https://issues.jboss.org/browse/TEIID-3116 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Minor > > Description of problem: > Querying a vdb-table which is formed as union of two tables from different datasources. Even though "set partialresultsmode true" is run as initial query, instead of retreiving 0 rows from a datasources that is down, exception is promoted. > Version-Release number of selected component (if applicable): > DV 6.1 ER1 > How reproducible: > Every time > Steps to Reproduce: > 1. Define one valid and one invalid datasource(invalid connection-url). > 2. Create vdb which maps tables from both datasources. > 3. Set partialresultsmode to true > 4. Execute query on the given vdb-table > Actual results: > TeiidSQLException > TEIID30498 Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for ORBQT were not avaialable. The command could not be planned properly. > Expected results: > 0 rows from invalid datasource. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3227) Add support for sub-expression pushing of must pushdown functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3227?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3227. --------------------------------- > Add support for sub-expression pushing of must pushdown functions > ----------------------------------------------------------------- > > Key: TEIID-3227 > URL: https://issues.jboss.org/browse/TEIID-3227 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 8.9 > Reporter: Michał Warecki > Assignee: Steven Hawkins > Priority: Minor > Fix For: 8.10 > > > As a user I'd like to have a possibility to push down sub-expressions of must pushdown functions. > Example: > Input query with not supported group by: > SELECT AAA, SUM(custom_function(BBB)) AS BBB_ALIAS FROM some_table WHERE some_table.CCC = 'VAL' GROUP BY AAA ORDER BY AAA > > Output query (processed by teiid): > SELECT AAA, BBB AS BBB_ALIAS FROM some_table.CCC = 'VAL' > > What I think it should looks like: > SELECT AAA, custom_function(BBB) AS BBB_ALIAS FROM some_table.CCC = 'VAL' > https://developer.jboss.org/message/910926#910926 -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3121) Teiid Standalone Server

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3121?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3121. --------------------------------- > Teiid Standalone Server > ----------------------- > > Key: TEIID-3121 > URL: https://issues.jboss.org/browse/TEIID-3121 > Project: Teiid > Issue Type: Feature Request > Components: Build/Kits > Reporter: Tom Arnold > Fix For: 8.10 > > > Perform the server installation steps as part of the build and add the result to the downloads page. It seems like this is something that everyone who isn't using the embedded kit has to do anyways, and would hopefully eliminate confusion caused by people trying to deploy the runtime in unsupported versions of JBoss. > * Teiid Runtime > * Teiid Web Console > * JBoss EAP 6.1 Alpha > * Resteasy JAX-RS Patch > End result would simplify the installation process to: > 1. Unzip Teiid server. > 2. Run `bin/add-user.sh` script. > 3. Deploy custom translators, VDB, etc. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 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 2015