June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3999) more aspects of materialization metadata should be validated

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3999?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3999: --------------------------------------- I think we should alter our handling of the semi-colon delimited scripts - the tokenizing logic we use won't tolerate having a semi-colon in the actual query. We can either account for an escape mechanism or recommend using an anonymous procedure block for multiple statements. > more aspects of materialization metadata should be validated > ------------------------------------------------------------ > > Key: TEIID-3999 > URL: https://issues.jboss.org/browse/TEIID-3999 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Kylin Soong > Priority: Minor > Fix For: 9.0 > > > * During metadata load we should check if the status table and the materialization scripts are valid, so there is at least a log of the issue rather than waiting for the exception to occur once the vdb is active. > * According to TEIID-4203, add an initial validation that validate the status table definition matches the expectation. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3999) more aspects of materialization metadata should be validated

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3999?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-3999: ------------------------------------ I have add parse / resolve / validate for validating load scripts, so far tables, scripts all will be validate, we may leave the further validation in future once a user requested. > more aspects of materialization metadata should be validated > ------------------------------------------------------------ > > Key: TEIID-3999 > URL: https://issues.jboss.org/browse/TEIID-3999 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Kylin Soong > Priority: Minor > Fix For: 9.0 > > > * During metadata load we should check if the status table and the materialization scripts are valid, so there is at least a log of the issue rather than waiting for the exception to occur once the vdb is active. > * According to TEIID-4203, add an initial validation that validate the status table definition matches the expectation. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3871) moving documentation from confluence to gitbook

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3871?page=com.atlassian.jira.plugin... ] Kylin Soong updated TEIID-3871: ------------------------------- Fix Version/s: 9.0 (was: 9.x) > moving documentation from confluence to gitbook > ------------------------------------------------- > > Key: TEIID-3871 > URL: https://issues.jboss.org/browse/TEIID-3871 > Project: Teiid > Issue Type: Task > Components: Documentation > Affects Versions: 9.x > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 9.0 > > > From Teiid DV 7 F2F Notes, > " In the Teiid 9.x timeframe we should look toward moving everything to gitbook / markdown. We should start by migrating the documentation and solicit help with the website if possible." > This issue will address this. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3871) moving documentation from confluence to gitbook

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3871?page=com.atlassian.jira.plugin... ] Kylin Soong resolved TEIID-3871. -------------------------------- Resolution: Done > moving documentation from confluence to gitbook > ------------------------------------------------- > > Key: TEIID-3871 > URL: https://issues.jboss.org/browse/TEIID-3871 > Project: Teiid > Issue Type: Task > Components: Documentation > Affects Versions: 9.x > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 9.0 > > > From Teiid DV 7 F2F Notes, > " In the Teiid 9.x timeframe we should look toward moving everything to gitbook / markdown. We should start by migrating the documentation and solicit help with the website if possible." > This issue will address this. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3926) update teiid website doc page to linked with gitbook adoc content.

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3926?page=com.atlassian.jira.plugin... ] Kylin Soong resolved TEIID-3926. -------------------------------- Resolution: Done Set to resolve due to the following contents in http://teiid.jboss.org/docs/ 9.x Release This is a work in progress. Please see the gitbooks. > update teiid website doc page to linked with gitbook adoc content. > ------------------------------------------------------------------ > > Key: TEIID-3926 > URL: https://issues.jboss.org/browse/TEIID-3926 > Project: Teiid > Issue Type: Sub-task > Components: Documentation > Reporter: Kylin Soong > Assignee: Steven Hawkins > Fix For: 9.x > > > Teiid 9.x version's document should add to http://teiid.jboss.org/docs/, this also base on "DV 7 Face To Face Notes" in mojo page -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3984) Enhance Reference Architecture document

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3984?page=com.atlassian.jira.plugin... ] Kylin Soong resolved TEIID-3984. -------------------------------- Resolution: Done > Enhance Reference Architecture document > --------------------------------------- > > Key: TEIID-3984 > URL: https://issues.jboss.org/browse/TEIID-3984 > Project: Teiid > Issue Type: Sub-task > Components: Documentation > Affects Versions: 9.x > Reporter: Kylin Soong > Assignee: Steven Hawkins > Fix For: 9.x > > > Architecture document lack the DQP Processing and Buffer Management doc, current [1] have very limited content, it's should be better if we can add document for DQP Processing, a Details Architecture Figure, some depicts of Buffer Management, it will be better. > [1] https://teiid.gitbooks.io/documents/content/reference/Architecture.html -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4235) dynamic sql recursion check not valid after caught exception

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4235?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4235: ---------------------------------- Fix Version/s: 8.12.5 > dynamic sql recursion check not valid after caught exception > ------------------------------------------------------------ > > Key: TEIID-4235 > URL: https://issues.jboss.org/browse/TEIID-4235 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.13.5 > > > With a procedure like: > begin > execute immediate > exception e > ... > execute immediate ... > An exception on the second execute immediate will be seen like: > org.teiid.api.exception.query.QueryProcessingException: TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE ..." due to: TEIID30347 There is a recursive invocation of group 'proc'. Please correct the SQL. > Even when the dynamic sql does not re-invoke the proc. The issue is that when catching the initial exception thrown doesn't clear the entry from the recursion stack. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4237) INNER JOIN returns incorrect results

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4237?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4237: ---------------------------------- Fix Version/s: 8.12.5 > INNER JOIN returns incorrect results > ------------------------------------ > > Key: TEIID-4237 > URL: https://issues.jboss.org/browse/TEIID-4237 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.12.5, 8.13.5 > > > Running the following query: > {code:sql} > select avg(t1.a) from > (select 3 as a, 3 as b union all > select 1 as a, 1 as b union all > select 3 as a, 3 as b) as t1 > join (select 1 as a, 1 as b union all > select 1 as a, 1 as b union all > select 2 as a, 2 as b union all > select 2 as a, 2 as b union all > select 3 as a, 3 as b union all > select 3 as a, 3 as b) as t2 on t1.a=t2.a > {code} > on teiid causes incorrect result: 2 in comparing with mysql which returns 2.333. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4238?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-4238 at 6/1/16 3:01 PM: --------------------------------------------------------------- > The quotes should be optional That is correct, but this is not a bug in that the current code is based upon the pg odbc client, which always quotes. Is this to support a different client or just a general request? was (Author: shawkins): > The quotes should be optional That is correct, but this is not a but in that the current code is based upon the pg odbc client, which always quotes. Is this to support a different client or just a general request? > 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 > > > 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)

8 years, 9 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4238?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4238: ---------------------------------- Issue Type: Enhancement (was: Bug) Component/s: ODBC Fix Version/s: 9.1 Workaround Description: Use a quoted cursor name. Workaround: Workaround Exists > 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 > > > 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)

8 years, 9 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 2016