[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
[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
[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
[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
[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
[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
[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