March 2013 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-1614) Procedure result set not being generated when creating simple CREATE VIRTUAL PROCEDURE from SQL

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1614?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-1614: ------------------------------------------ Yes, it is not needed by Teiid as we will always have the metadata for the procedure defined before resolving it. > Procedure result set not being generated when creating simple CREATE VIRTUAL PROCEDURE from SQL > ----------------------------------------------------------------------------------------------- > > Key: TEIIDDES-1614 > URL: https://issues.jboss.org/browse/TEIIDDES-1614 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling, Validation > Affects Versions: 8.1 > Reporter: Barry LaFond > Assignee: Paul Richardson > Fix For: 8.1 > > Attachments: DynamicSQLMPS.zip > > > Designer 7.7.x will auto-generated the virtual procedure result set and columns after pasting in the following: > CREATE VIRTUAL PROCEDURE > BEGIN > SELECT * FROM PARTS; > END > Current Designer 8.1 codebase results in valid SQL (no errors) but the result set and columns are not generated. > When creating a Web Service Model/Operation from same PARTS source table the resulting Operation will have a resulting OUTPUT (result set) but no output column with XML type -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1614) Procedure result set not being generated when creating simple CREATE VIRTUAL PROCEDURE from SQL

by Paul Richardson (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1614?page=com.atlassian.jira.plu... ] Paul Richardson commented on TEIIDDES-1614: ------------------------------------------- The 'inferProcedureResultSetColumns' flag was added, to the resolveCommand code in TEIID-2421, to allow for the inferring of the result set columns. What I was wondering is since this is a special flag that has been added for designer, is the inference of result set columns never required by teiid? The answer to my third question (above), indicates a likely 'yes' > Procedure result set not being generated when creating simple CREATE VIRTUAL PROCEDURE from SQL > ----------------------------------------------------------------------------------------------- > > Key: TEIIDDES-1614 > URL: https://issues.jboss.org/browse/TEIIDDES-1614 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling, Validation > Affects Versions: 8.1 > Reporter: Barry LaFond > Assignee: Paul Richardson > Fix For: 8.1 > > Attachments: DynamicSQLMPS.zip > > > Designer 7.7.x will auto-generated the virtual procedure result set and columns after pasting in the following: > CREATE VIRTUAL PROCEDURE > BEGIN > SELECT * FROM PARTS; > END > Current Designer 8.1 codebase results in valid SQL (no errors) but the result set and columns are not generated. > When creating a Web Service Model/Operation from same PARTS source table the resulting Operation will have a resulting OUTPUT (result set) but no output column with XML type -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1614) Procedure result set not being generated when creating simple CREATE VIRTUAL PROCEDURE from SQL

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1614?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-1614: ------------------------------------------ > What is the difference between the resultSetColumns and projectSymbols collections? Projected columns for procedures may also include out/inout/return parameters. > If the 2 collections are interchangeable why there are 2 collections? They are not interchangable. > Why in 7.7 did the projectedSymbols get populated with the contents of resultSetColumns and yet in 8.2+ this is no longer the case? The old code was problematic in several ways. First it stored the entire "results command" on the resolved create, which was not necessary and led to clone and improper usage later. Second it didn't properly differentiate between projected columns and result set columns, which is needed in virtual procedure invocation to make parameter assignments based upon out/inout/return values. Third the code in general did not properly account for the case where there is no result set defined in the metadata - which is somewhat the crux of this issue. Designer is giving us metadata for the procedure that is entirely valid - no result set and no parameters and asking us to resolve the procedure - and yet also wants to know the possible result set columns. > The inclusion of the 'inferProcedureResultSetColumns' is a workaround for designer to get back the columns so is any of this not required by teiid anymore? I'm not sure what that means. Could you elaborate? > Procedure result set not being generated when creating simple CREATE VIRTUAL PROCEDURE from SQL > ----------------------------------------------------------------------------------------------- > > Key: TEIIDDES-1614 > URL: https://issues.jboss.org/browse/TEIIDDES-1614 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling, Validation > Affects Versions: 8.1 > Reporter: Barry LaFond > Assignee: Paul Richardson > Fix For: 8.1 > > Attachments: DynamicSQLMPS.zip > > > Designer 7.7.x will auto-generated the virtual procedure result set and columns after pasting in the following: > CREATE VIRTUAL PROCEDURE > BEGIN > SELECT * FROM PARTS; > END > Current Designer 8.1 codebase results in valid SQL (no errors) but the result set and columns are not generated. > When creating a Web Service Model/Operation from same PARTS source table the resulting Operation will have a resulting OUTPUT (result set) but no output column with XML type -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1614) Procedure result set not being generated when creating simple CREATE VIRTUAL PROCEDURE from SQL

by Paul Richardson (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1614?page=com.atlassian.jira.plu... ] Paul Richardson commented on TEIIDDES-1614: ------------------------------------------- With 34 references to getProjectedSymbols() in designer's codebase and the possibility that many of those relate to other types of Command, that seems a worrying workaround to the problem. Would you mind explaining: * What is the difference between the resultSetColumns and projectSymbols collections? * If the 2 collections are interchangeable why there are 2 collections? * Why in 7.7 did the projectedSymbols get populated with the contents of resultSetColumns and yet in 8.2+ this is no longer the case? * The inclusion of the 'inferProcedureResultSetColumns' is a workaround for designer to get back the columns so is any of this not required by teiid anymore? Many thanks. > Procedure result set not being generated when creating simple CREATE VIRTUAL PROCEDURE from SQL > ----------------------------------------------------------------------------------------------- > > Key: TEIIDDES-1614 > URL: https://issues.jboss.org/browse/TEIIDDES-1614 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling, Validation > Affects Versions: 8.1 > Reporter: Barry LaFond > Assignee: Paul Richardson > Fix For: 8.1 > > Attachments: DynamicSQLMPS.zip > > > Designer 7.7.x will auto-generated the virtual procedure result set and columns after pasting in the following: > CREATE VIRTUAL PROCEDURE > BEGIN > SELECT * FROM PARTS; > END > Current Designer 8.1 codebase results in valid SQL (no errors) but the result set and columns are not generated. > When creating a Web Service Model/Operation from same PARTS source table the resulting Operation will have a resulting OUTPUT (result set) but no output column with XML type -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1531) Exception when updating Oracle NVARCHAR2 columns

by Mark Drilling (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1531?page=com.atlassian.jira.plu... ] Mark Drilling resolved TEIIDDES-1531. ------------------------------------- Resolution: Cannot Reproduce Bug Tested OK > Exception when updating Oracle NVARCHAR2 columns > ------------------------------------------------ > > Key: TEIIDDES-1531 > URL: https://issues.jboss.org/browse/TEIIDDES-1531 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Environment: Windows 7 64 bit, Eclipse Indigo, Oracle jdbc thin 11.2.0.2.0 > Reporter: I Leitch > Assignee: Mark Drilling > Fix For: 8.1 > > > If it doesn't already do so, the Oracle importer should import NVARCHAR2 (type 1111) and VARCHAR2 (type 12) as string. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1531) Exception when updating Oracle NVARCHAR2 columns

by Mark Drilling (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1531?page=com.atlassian.jira.plu... ] Mark Drilling commented on TEIIDDES-1531: ----------------------------------------- Tested this issue in Designer - Eclipse 4.2 Juno, using the Designer 8.1Alpha download. Teiid server was Teiid 8.2 Final running in AS 7.1.1... In Designer, both the VARCHAR2 and NVARCHAR2 were imported as string. I successfully ran a preview, then created and executed a VDB. SELECT queries ran fine. I then ran separate UPDATE queries, updating each of the different column types. Those were successful also. I'm closing this issue as not reproducible - assume it has been addressed since logged. Please re-open with further detail if problems still exist. > Exception when updating Oracle NVARCHAR2 columns > ------------------------------------------------ > > Key: TEIIDDES-1531 > URL: https://issues.jboss.org/browse/TEIIDDES-1531 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Environment: Windows 7 64 bit, Eclipse Indigo, Oracle jdbc thin 11.2.0.2.0 > Reporter: I Leitch > Assignee: Mark Drilling > Fix For: 8.1 > > > If it doesn't already do so, the Oracle importer should import NVARCHAR2 (type 1111) and VARCHAR2 (type 12) as string. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1635) Designer is not showing the same error in the server log

by Van Halbert (JIRA)

Van Halbert created TEIIDDES-1635: ------------------------------------- Summary: Designer is not showing the same error in the server log Key: TEIIDDES-1635 URL: https://issues.jboss.org/browse/TEIIDDES-1635 Project: Teiid Designer Issue Type: Feature Request Components: Usability Affects Versions: 7.4 Reporter: Van Halbert JBoss developer studio is not returning complete error stack trace. For example, running a query throws error in the designer which is different from error in server log and we would like to get the error whatever is there in the server.log to troubleshoot and fix the issues. It's really difficult for developers to understand and fix the issues with the way error is shown in the designer compared to more useful error shown in the server.log. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1634) For Komodo, remove UUID from the persisted models, will help with ability to merge models

by Van Halbert (JIRA)

Van Halbert created TEIIDDES-1634: ------------------------------------- Summary: For Komodo, remove UUID from the persisted models, will help with ability to merge models Key: TEIIDDES-1634 URL: https://issues.jboss.org/browse/TEIIDDES-1634 Project: Teiid Designer Issue Type: Feature Request Components: Modeling Reporter: Van Halbert When saving a model file, don't persist the UUID's in the file. This would make the file smaller and help with the user's ability to manage their models in a SCM and merge the changes. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1448) Data roles' Confirm State Change dialog cannot be disabled

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1448?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-1448. ------------------------------------ Resolution: Done Done > Data roles' Confirm State Change dialog cannot be disabled > ---------------------------------------------------------- > > Key: TEIIDDES-1448 > URL: https://issues.jboss.org/browse/TEIIDDES-1448 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 7.7.1 > Environment: Windows 7 & JBDS 5 with SOA-tooling CR2 > Reporter: Paul Nittel > Assignee: Barry LaFond > Priority: Minor > Fix For: 8.1 > > Attachments: ConfirmStateChange.png > > > Defining a data role may entail restricting access to an entire model (for example). When the READ option is disabled, the Confirm State Change dialog notifies the user that all children of the selected object will be affected by this change. > There is no way to stop the dialog, so it becomes an obstacle to the user's efforts. It needs one of those "Don't display this any more" checkboxes. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1448) Data roles' Confirm State Change dialog cannot be disabled

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1448?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-1448: ----------------------------------- Fix Version/s: 8.1 > Data roles' Confirm State Change dialog cannot be disabled > ---------------------------------------------------------- > > Key: TEIIDDES-1448 > URL: https://issues.jboss.org/browse/TEIIDDES-1448 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 7.7.1 > Environment: Windows 7 & JBDS 5 with SOA-tooling CR2 > Reporter: Paul Nittel > Priority: Minor > Fix For: 8.1 > > Attachments: ConfirmStateChange.png > > > Defining a data role may entail restricting access to an entire model (for example). When the READ option is disabled, the Confirm State Change dialog notifies the user that all children of the selected object will be affected by this change. > There is no way to stop the dialog, so it becomes an obstacle to the user's efforts. It needs one of those "Don't display this any more" checkboxes. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues March 2013