October 2015 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2562) Transformation editor does not save the code, "create virtual procedure"

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2562?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-2562 at 10/13/15 10:07 AM: ------------------------------------------------------------------- 9.0.x: https://github.com/Teiid-Designer/teiid-designer/pull/494 Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1233040|https://bugzilla.redhat.com/show_bug.cgi?id=1233040] from NEW to CLOSED was (Author: jira-bugzilla-migration): Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1233040|https://bugzilla.redhat.com/show_bug.cgi?id=1233040] from NEW to CLOSED > Transformation editor does not save the code, "create virtual procedure" > ------------------------------------------------------------------------ > > Key: TEIIDDES-2562 > URL: https://issues.jboss.org/browse/TEIIDDES-2562 > Project: Teiid Designer > Issue Type: Bug > Components: Editors > Affects Versions: 9.0.1 > Environment: JBDS 8.1.0.GA with Teiid Designer 9.0.1.Final-v20150211-1407-B643 > Reporter: hisao furuichi > Assignee: Paul Richardson > Fix For: 9.0.4, 9.3 > > Attachments: ErrorProject.zip > > > Transformation editor does not save the code, "create virtual procedure". > Additional information: > - Official documents introduces the chaced virtual procedure function > https://access.redhat.com/documentation/en-US/Red_Hat_JBoss_Data_Virtuali... > - It works with JBDS 7.1.1.GA with Teiid Designer 8.3.4.Final-v20140912-1304-B264 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2562) Transformation editor does not save the code, "create virtual procedure"

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2562?page=com.atlassian.jira.plu... ] Barry LaFond reopened TEIIDDES-2562: ------------------------------------ > Transformation editor does not save the code, "create virtual procedure" > ------------------------------------------------------------------------ > > Key: TEIIDDES-2562 > URL: https://issues.jboss.org/browse/TEIIDDES-2562 > Project: Teiid Designer > Issue Type: Bug > Components: Editors > Affects Versions: 9.0.1 > Environment: JBDS 8.1.0.GA with Teiid Designer 9.0.1.Final-v20150211-1407-B643 > Reporter: hisao furuichi > Assignee: Paul Richardson > Fix For: 9.0.4, 9.3 > > Attachments: ErrorProject.zip > > > Transformation editor does not save the code, "create virtual procedure". > Additional information: > - Official documents introduces the chaced virtual procedure function > https://access.redhat.com/documentation/en-US/Red_Hat_JBoss_Data_Virtuali... > - It works with JBDS 7.1.1.GA with Teiid Designer 8.3.4.Final-v20140912-1304-B264 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2687) Dynamic VDB generation - Default value for string column problem (DDL)

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2687?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-2687: ------------------------------------------ Yes, that extension means treat the string as if it were an expression - but it would still be parsed as a string. > Dynamic VDB generation - Default value for string column problem (DDL) > ---------------------------------------------------------------------- > > Key: TEIIDDES-2687 > URL: https://issues.jboss.org/browse/TEIIDDES-2687 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 9.0.4 > Reporter: Matus Makovy > > I have a model with table that has String column with default value "Stock". > DDL generated by TD for dynamic VDB looks like this: > {quote} > ... > TYPE string(15) DEFAULT ('Stock') OPTIONS(NAMEINSOURCE '"TYPE"', NATIVE_TYPE 'VARCHAR2', UPDATABLE 'FALSE'), > ... > {quote} > *DEFAULT ('Stock')* is not correct, it should be: *DEFAULT '("Stock")'* -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2687) Dynamic VDB generation - Default value for string column problem (DDL)

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2687?page=com.atlassian.jira.plu... ] Ramesh Reddy commented on TEIIDDES-2687: ---------------------------------------- So paren(s) mean an expression? Also I found this in DDL Metadata docs {quote} Currently only string values are supported as the default value. To have the string interpreted as an expression use the extension property teiid_rel:default_handling set to expression. {quote} > Dynamic VDB generation - Default value for string column problem (DDL) > ---------------------------------------------------------------------- > > Key: TEIIDDES-2687 > URL: https://issues.jboss.org/browse/TEIIDDES-2687 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 9.0.4 > Reporter: Matus Makovy > > I have a model with table that has String column with default value "Stock". > DDL generated by TD for dynamic VDB looks like this: > {quote} > ... > TYPE string(15) DEFAULT ('Stock') OPTIONS(NAMEINSOURCE '"TYPE"', NATIVE_TYPE 'VARCHAR2', UPDATABLE 'FALSE'), > ... > {quote} > *DEFAULT ('Stock')* is not correct, it should be: *DEFAULT '("Stock")'* -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2687) Dynamic VDB generation - Default value for string column problem (DDL)

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2687?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-2687: ------------------------------------------ Currently the default must be a string literal, so ('STOCK') will not be correct. There have been some changes here of late, but more changes are needed to handle this fully - TEIID-3750 > Dynamic VDB generation - Default value for string column problem (DDL) > ---------------------------------------------------------------------- > > Key: TEIIDDES-2687 > URL: https://issues.jboss.org/browse/TEIIDDES-2687 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 9.0.4 > Reporter: Matus Makovy > > I have a model with table that has String column with default value "Stock". > DDL generated by TD for dynamic VDB looks like this: > {quote} > ... > TYPE string(15) DEFAULT ('Stock') OPTIONS(NAMEINSOURCE '"TYPE"', NATIVE_TYPE 'VARCHAR2', UPDATABLE 'FALSE'), > ... > {quote} > *DEFAULT ('Stock')* is not correct, it should be: *DEFAULT '("Stock")'* -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2687) Dynamic VDB generation - Default value for string column problem (DDL)

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2687?page=com.atlassian.jira.plu... ] Ramesh Reddy commented on TEIIDDES-2687: ---------------------------------------- DEFAULT('STOCK') is correct. The reason NAMEINSOURCE is like '"TYPE"' is TYPE is reserved word, whereas 'STOCK' is NOT > Dynamic VDB generation - Default value for string column problem (DDL) > ---------------------------------------------------------------------- > > Key: TEIIDDES-2687 > URL: https://issues.jboss.org/browse/TEIIDDES-2687 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 9.0.4 > Reporter: Matus Makovy > > I have a model with table that has String column with default value "Stock". > DDL generated by TD for dynamic VDB looks like this: > {quote} > ... > TYPE string(15) DEFAULT ('Stock') OPTIONS(NAMEINSOURCE '"TYPE"', NATIVE_TYPE 'VARCHAR2', UPDATABLE 'FALSE'), > ... > {quote} > *DEFAULT ('Stock')* is not correct, it should be: *DEFAULT '("Stock")'* -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2688) Dynamic VDB Generation - Problem with DDL generated for procedure

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2688?page=com.atlassian.jira.plu... ] RH Bugzilla Integration updated TEIIDDES-2688: ---------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1271233 Bugzilla Update: Perform > Dynamic VDB Generation - Problem with DDL generated for procedure > ----------------------------------------------------------------- > > Key: TEIIDDES-2688 > URL: https://issues.jboss.org/browse/TEIIDDES-2688 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.4 > Reporter: Matus Makovy > > I have a VDB that was created for consumption of REST Web Service. > There is a procedure named getProgrammes(). DDL generated for dynamic VDB is: > {quote} > CREATE VIRTUAL PROCEDURE getProgrammes () > AS > CREATE VIRTUAL PROCEDURE > BEGIN > DECLARE STRING VARIABLES.qp = ''; > SELECT > A.pid AS pid, A."start" AS "start", A."end" AS "end", A.title AS title > FROM > (EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE')) AS f, XMLTABLE('/schedule' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS pid string PATH 'day/broadcasts/broadcast/pid/text()', "start" string PATH 'day/broadcasts/broadcast/start/text()', "end" string PATH 'day/broadcasts/broadcast/end/text()', title string PATH 'day/broadcasts/broadcast/programme/title/text()') AS A; > END; > {quote} > Obviously, there is one extra "CREATE VIRTUAL PROCEDURE". > Even after fixing this issue there is another error: > {quote} > VDB: REST State: INACTIVE ERROR: TEIID31080 ViewModel.getProgrammes validation error: TEIID31118 Element "f.result" is not defined by any relevant group. ERROR: TEIID31080 ViewModel.getProgrammes1 validation error: TEIID31118 Element "f.result" is not defined by any relevant group. Models: SourceModel ViewModel > {quote} > "f" should be a refrence to "EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE'))" as descibed in the SQL -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2688) Dynamic VDB Generation - Problem with DDL generated for procedure

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2688?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2688: ----------------------------------- Description: I have a VDB that was created for consumption of REST Web Service. There is a procedure named getProgrammes(). DDL generated for dynamic VDB is: {quote} CREATE VIRTUAL PROCEDURE getProgrammes () AS CREATE VIRTUAL PROCEDURE BEGIN DECLARE STRING VARIABLES.qp = ''; SELECT A.pid AS pid, A."start" AS "start", A."end" AS "end", A.title AS title FROM (EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE')) AS f, XMLTABLE('/schedule' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS pid string PATH 'day/broadcasts/broadcast/pid/text()', "start" string PATH 'day/broadcasts/broadcast/start/text()', "end" string PATH 'day/broadcasts/broadcast/end/text()', title string PATH 'day/broadcasts/broadcast/programme/title/text()') AS A; END; {quote} Obviously, there is one extra "CREATE VIRTUAL PROCEDURE". Even after fixing this issue there is another error: {quote} VDB: REST State: INACTIVE ERROR: TEIID31080 ViewModel.getProgrammes validation error: TEIID31118 Element "f.result" is not defined by any relevant group. ERROR: TEIID31080 ViewModel.getProgrammes1 validation error: TEIID31118 Element "f.result" is not defined by any relevant group. Models: SourceModel ViewModel {quote} "f" should be a refrence to "EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE'))" as descibed in the SQL was: I have a VDB that was created for consumption of REST Web Service. There is a procedure named getProgrammes(). DDL generated for dynamic VDB is: {quote} CREATE VIRTUAL PROCEDURE getProgrammes () AS CREATE VIRTUAL PROCEDURE BEGIN DECLARE STRING VARIABLES.qp = ''; SELECT A.pid AS pid, A."start" AS "start", A."end" AS "end", A.title AS title FROM (EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE')) AS f, XMLTABLE('/schedule' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS pid string PATH 'day/broadcasts/broadcast/pid/text()', "start" string PATH 'day/broadcasts/broadcast/start/text()', "end" string PATH 'day/broadcasts/broadcast/end/text()', title string PATH 'day/broadcasts/broadcast/programme/title/text()') AS A; END; {quote} Obviously there is one "CREATE VIRTUAL PROCEDURE" extra. Even after fixing this issue there is another error: {quote} VDB: REST State: INACTIVE ERROR: TEIID31080 ViewModel.getProgrammes validation error: TEIID31118 Element "f.result" is not defined by any relevant group. ERROR: TEIID31080 ViewModel.getProgrammes1 validation error: TEIID31118 Element "f.result" is not defined by any relevant group. Models: SourceModel ViewModel {quote} "f" should be a refrence to "EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE'))" as descibed in the SQL > Dynamic VDB Generation - Problem with DDL generated for procedure > ----------------------------------------------------------------- > > Key: TEIIDDES-2688 > URL: https://issues.jboss.org/browse/TEIIDDES-2688 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.4 > Reporter: Matus Makovy > > I have a VDB that was created for consumption of REST Web Service. > There is a procedure named getProgrammes(). DDL generated for dynamic VDB is: > {quote} > CREATE VIRTUAL PROCEDURE getProgrammes () > AS > CREATE VIRTUAL PROCEDURE > BEGIN > DECLARE STRING VARIABLES.qp = ''; > SELECT > A.pid AS pid, A."start" AS "start", A."end" AS "end", A.title AS title > FROM > (EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE')) AS f, XMLTABLE('/schedule' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS pid string PATH 'day/broadcasts/broadcast/pid/text()', "start" string PATH 'day/broadcasts/broadcast/start/text()', "end" string PATH 'day/broadcasts/broadcast/end/text()', title string PATH 'day/broadcasts/broadcast/programme/title/text()') AS A; > END; > {quote} > Obviously, there is one extra "CREATE VIRTUAL PROCEDURE". > Even after fixing this issue there is another error: > {quote} > VDB: REST State: INACTIVE ERROR: TEIID31080 ViewModel.getProgrammes validation error: TEIID31118 Element "f.result" is not defined by any relevant group. ERROR: TEIID31080 ViewModel.getProgrammes1 validation error: TEIID31118 Element "f.result" is not defined by any relevant group. Models: SourceModel ViewModel > {quote} > "f" should be a refrence to "EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE'))" as descibed in the SQL -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2688) Dynamic VDB Generation - Problem with DDL generated for procedure

by Matus Makovy (JIRA)

Matus Makovy created TEIIDDES-2688: -------------------------------------- Summary: Dynamic VDB Generation - Problem with DDL generated for procedure Key: TEIIDDES-2688 URL: https://issues.jboss.org/browse/TEIIDDES-2688 Project: Teiid Designer Issue Type: Bug Affects Versions: 9.0.4 Reporter: Matus Makovy I have a VDB that was created for consumption of REST Web Service. There is a procedure named getProgrammes(). DDL generated for dynamic VDB is: {quote} CREATE VIRTUAL PROCEDURE getProgrammes () AS CREATE VIRTUAL PROCEDURE BEGIN DECLARE STRING VARIABLES.qp = ''; SELECT A.pid AS pid, A."start" AS "start", A."end" AS "end", A.title AS title FROM (EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE')) AS f, XMLTABLE('/schedule' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS pid string PATH 'day/broadcasts/broadcast/pid/text()', "start" string PATH 'day/broadcasts/broadcast/start/text()', "end" string PATH 'day/broadcasts/broadcast/end/text()', title string PATH 'day/broadcasts/broadcast/programme/title/text()') AS A; END; {quote} Obviously there is one "CREATE VIRTUAL PROCEDURE" extra. Even after fixing this issue there is another error: {quote} VDB: REST State: INACTIVE ERROR: TEIID31080 ViewModel.getProgrammes validation error: TEIID31118 Element "f.result" is not defined by any relevant group. ERROR: TEIID31080 ViewModel.getProgrammes1 validation error: TEIID31118 Element "f.result" is not defined by any relevant group. Models: SourceModel ViewModel {quote} "f" should be a refrence to "EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE'))" as descibed in the SQL -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2687) Dynamic VDB generation - Default value for string column problem (DDL)

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2687?page=com.atlassian.jira.plu... ] RH Bugzilla Integration updated TEIIDDES-2687: ---------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1271226 Bugzilla Update: Perform > Dynamic VDB generation - Default value for string column problem (DDL) > ---------------------------------------------------------------------- > > Key: TEIIDDES-2687 > URL: https://issues.jboss.org/browse/TEIIDDES-2687 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 9.0.4 > Reporter: Matus Makovy > > I have a model with table that has String column with default value "Stock". > DDL generated by TD for dynamic VDB looks like this: > {quote} > ... > TYPE string(15) DEFAULT ('Stock') OPTIONS(NAMEINSOURCE '"TYPE"', NATIVE_TYPE 'VARCHAR2', UPDATABLE 'FALSE'), > ... > {quote} > *DEFAULT ('Stock')* is not correct, it should be: *DEFAULT '("Stock")'* -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues October 2015