[JBoss JIRA] (TEIIDDES-2788) Access Pattern not generated when exporting dynamic VDB
by Andrej Šmigala (JIRA)
Andrej Šmigala created TEIIDDES-2788:
----------------------------------------
Summary: Access Pattern not generated when exporting dynamic VDB
Key: TEIIDDES-2788
URL: https://issues.jboss.org/browse/TEIIDDES-2788
Project: Teiid Designer
Issue Type: Bug
Components: Dynamic VDBs
Affects Versions: 9.0.4
Reporter: Andrej Šmigala
Attachments: APproj.zip
When exporting a dynamic VDB, access pattern constrains on model tables are not exported.
Actual DDL:
{code:sql}
CREATE FOREIGN TABLE s1 (
newColumn_1 string(4000),
newColumn_2 string(4000)
)
{code}
Expected DDL:
{code:sql}
CREATE FOREIGN TABLE s1 (
newColumn_1 string(4000),
newColumn_2 string(4000),
CONSTRAINT NewAccessPattern ACCESSPATTERN (newColumn_1)
)
{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIIDDES-2787) VDB synchronize shows errors
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2787?page=com.atlassian.jira.plu... ]
Matus Makovy commented on TEIIDDES-2787:
----------------------------------------
This happens only if you have DV-6.3.0.DR3 server set as default server in TD, it works with older version of server.
> VDB synchronize shows errors
> ----------------------------
>
> Key: TEIIDDES-2787
> URL: https://issues.jboss.org/browse/TEIIDDES-2787
> Project: Teiid Designer
> Issue Type: Bug
> Components: VDB & Execution
> Affects Versions: 10.0.1
> Environment: Fedora 23
> jbds-9.1.0.Beta2_jbdsis-9.0.0.Beta1 + dv-6.3.0.DR3
> Reporter: Matej Kralik
> Attachments: Screenshot from 2016-02-19 11-37-17.png
>
>
> When I changed something in the model and synchronize the VDB (with the DV 6.3.0 server), shows me "
> This VDB was created in a newer version of Designer hence may contain properties that are not compatible with this version." error. However VDB works normal. (deploy, execute VDB, create data source). Maybe it should be only the warning.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIIDDES-2469) [Usability] Problem importing SOAP web service via URL
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2469?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2469:
-----------------------------------
Labels: release_notes verified_jbdsis-9.0.0.Beta (was: )
> [Usability] Problem importing SOAP web service via URL
> ------------------------------------------------------
>
> Key: TEIIDDES-2469
> URL: https://issues.jboss.org/browse/TEIIDDES-2469
> Project: Teiid Designer
> Issue Type: Quality Risk
> Components: Import/Export, Patch Release
> Affects Versions: 9.0
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Labels: release_notes, verified_jbdsis-9.0.0.Beta
> Fix For: 10.0.1, 9.2.1
>
> Attachments: bug.mov, define-rest-procedure-tags-dialog.png
>
>
> Conversation:
> [09:44] <jmarley> vhalbert: do you have a document for import soap web service via url
> [09:45] <jmarley> we are getting hung up on creating relational model
> [09:45] <jmarley> vhalbert: nevermind,
> [09:46] <jmarley> vhalbert: there was an error saying we didn't have a column defined, but it was for a different procedure than the one that was selected, which and we didn't know we needed to select the other procedure and assumed it was issue with current procedure we were working with
> [09:47] <vhalbert> jmarley, hm
> [09:47] <vhalbert> jmarley, so designer was processing something that wasn't selected
> [09:48] <jmarley> vhalbert: yes, and didn't give an indication as to which procedure it was referring to
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIIDDES-2469) [Usability] Problem importing SOAP web service via URL
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2469?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2469.
----------------------------------
> [Usability] Problem importing SOAP web service via URL
> ------------------------------------------------------
>
> Key: TEIIDDES-2469
> URL: https://issues.jboss.org/browse/TEIIDDES-2469
> Project: Teiid Designer
> Issue Type: Quality Risk
> Components: Import/Export, Patch Release
> Affects Versions: 9.0
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Labels: release_notes, verified_jbdsis-9.0.0.Beta
> Fix For: 10.0.1, 9.2.1
>
> Attachments: bug.mov, define-rest-procedure-tags-dialog.png
>
>
> Conversation:
> [09:44] <jmarley> vhalbert: do you have a document for import soap web service via url
> [09:45] <jmarley> we are getting hung up on creating relational model
> [09:45] <jmarley> vhalbert: nevermind,
> [09:46] <jmarley> vhalbert: there was an error saying we didn't have a column defined, but it was for a different procedure than the one that was selected, which and we didn't know we needed to select the other procedure and assumed it was issue with current procedure we were working with
> [09:47] <vhalbert> jmarley, hm
> [09:47] <vhalbert> jmarley, so designer was processing something that wasn't selected
> [09:48] <jmarley> vhalbert: yes, and didn't give an indication as to which procedure it was referring to
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIIDDES-2738) REST procedure not imported correctly from dynamic VDB
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2738?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2738:
-----------------------------------
Labels: release_notes verified_jbdsis-9.0.0.Beta (was: )
> REST procedure not imported correctly from dynamic VDB
> -------------------------------------------------------
>
> Key: TEIIDDES-2738
> URL: https://issues.jboss.org/browse/TEIIDDES-2738
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, Patch Release, VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Labels: release_notes, verified_jbdsis-9.0.0.Beta
> Fix For: 10.0.1, 9.2.1
>
>
> When importing a dynamic VDB with REST procedure, the created procedure does not have the REST options set.
> {code:xml}
> <?xml version="1.0" encoding="UTF-8" standalone="no"?>
> <vdb name="RestProcedureVdbDynamic" version="1">
> <description />
> <property name="{http://teiid.org/rest}auto-generate" value="true" />
> <model name="ProcedureModel" type="VIRTUAL">
> <metadata type="DDL"><![CDATA[
> SET NAMESPACE 'http://teiid.org/rest' AS REST;
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}')
> AS
> BEGIN
> SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> ]]></metadata>
> </model>
> </vdb>
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIIDDES-2738) REST procedure not imported correctly from dynamic VDB
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2738?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2738.
----------------------------------
> REST procedure not imported correctly from dynamic VDB
> -------------------------------------------------------
>
> Key: TEIIDDES-2738
> URL: https://issues.jboss.org/browse/TEIIDDES-2738
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, Patch Release, VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Labels: release_notes, verified_jbdsis-9.0.0.Beta
> Fix For: 10.0.1, 9.2.1
>
>
> When importing a dynamic VDB with REST procedure, the created procedure does not have the REST options set.
> {code:xml}
> <?xml version="1.0" encoding="UTF-8" standalone="no"?>
> <vdb name="RestProcedureVdbDynamic" version="1">
> <description />
> <property name="{http://teiid.org/rest}auto-generate" value="true" />
> <model name="ProcedureModel" type="VIRTUAL">
> <metadata type="DDL"><![CDATA[
> SET NAMESPACE 'http://teiid.org/rest' AS REST;
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}')
> AS
> BEGIN
> SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> ]]></metadata>
> </model>
> </vdb>
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIIDDES-2787) VDB synchronize shows errors
by Matej Kralik (JIRA)
Matej Kralik created TEIIDDES-2787:
--------------------------------------
Summary: VDB synchronize shows errors
Key: TEIIDDES-2787
URL: https://issues.jboss.org/browse/TEIIDDES-2787
Project: Teiid Designer
Issue Type: Bug
Components: VDB & Execution
Affects Versions: 10.0.1
Environment: Fedora 23
jbds-9.1.0.Beta2_jbdsis-9.0.0.Beta1 + dv-6.3.0.DR3
Reporter: Matej Kralik
Attachments: Screenshot from 2016-02-19 11-37-17.png
When I changed something in the model and synchronize the VDB (with the DV 6.3.0 server), shows me "
This VDB was created in a newer version of Designer hence may contain properties that are not compatible with this version." error. However VDB works normal. (deploy, execute VDB, create data source). Maybe it should be only the warning.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIIDDES-2719) DDL for UDF in exported dynamic VDB contains RETURN parameter
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2719?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2719:
-----------------------------------
Labels: release_notes verified_jbdsis-9.0.0.Beta (was: )
> DDL for UDF in exported dynamic VDB contains RETURN parameter
> -------------------------------------------------------------
>
> Key: TEIIDDES-2719
> URL: https://issues.jboss.org/browse/TEIIDDES-2719
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Import/Export, Patch Release
> Affects Versions: 9.2
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Labels: release_notes, verified_jbdsis-9.0.0.Beta
> Fix For: 10.0.1, 9.2.1
>
> Attachments: UdfProject.zip
>
>
> When exporting VDB with a UDF, the resulting DDL contains the RETURN parameter in the parameters list. According to the [Teiid docs|https://docs.jboss.org/author/display/teiid87final/Support+for+User-...], the return parameter should not be specified.
> Generated DDL:
> {code:sql}
> CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000), result string(4000)) RETURNS string
> ) OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull')
> {code}
> Expected DDL:
> {code:sql}
> CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000)) RETURNS string
> OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull')
> {code}
> (note that the generated DDL also contains an unrelated syntax error due to TEIIDDES-2697)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIIDDES-2719) DDL for UDF in exported dynamic VDB contains RETURN parameter
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2719?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2719.
----------------------------------
> DDL for UDF in exported dynamic VDB contains RETURN parameter
> -------------------------------------------------------------
>
> Key: TEIIDDES-2719
> URL: https://issues.jboss.org/browse/TEIIDDES-2719
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Import/Export, Patch Release
> Affects Versions: 9.2
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Labels: release_notes, verified_jbdsis-9.0.0.Beta
> Fix For: 10.0.1, 9.2.1
>
> Attachments: UdfProject.zip
>
>
> When exporting VDB with a UDF, the resulting DDL contains the RETURN parameter in the parameters list. According to the [Teiid docs|https://docs.jboss.org/author/display/teiid87final/Support+for+User-...], the return parameter should not be specified.
> Generated DDL:
> {code:sql}
> CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000), result string(4000)) RETURNS string
> ) OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull')
> {code}
> Expected DDL:
> {code:sql}
> CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000)) RETURNS string
> OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull')
> {code}
> (note that the generated DDL also contains an unrelated syntax error due to TEIIDDES-2697)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months