January 2011 - teiid-designer-issues

[JBoss JIRA] Created: (TEIIDDES-640) Exporting a relational to ddl, and turned off the comments option did not eliminate the comments from the ddl file.

by Van Halbert (JIRA)

Exporting a relational to ddl, and turned off the comments option did not eliminate the comments from the ddl file. ------------------------------------------------------------------------------------------------------------------- Key: TEIIDDES-640 URL: https://jira.jboss.org/browse/TEIIDDES-640 Project: Teiid Designer Issue Type: Bug Components: Import/Export Reporter: Van Halbert Priority: Minor Fix For: 7.1.1 Using the export option to DDL, and changed the option to remove comments from being put into the ddl file, did not work. All the comments appeared there. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 9 months

3
12
0 / 0

[JBoss JIRA] Created: (TEIIDDES-518) DTP context menu options on Teiid tables should consider whether virtual model supports update.

by Ken Johnson (JIRA)

DTP context menu options on Teiid tables should consider whether virtual model supports update. ----------------------------------------------------------------------------------------------- Key: TEIIDDES-518 URL: https://jira.jboss.org/browse/TEIIDDES-518 Project: Teiid Designer Issue Type: Bug Affects Versions: 7.0 Environment: Teiid Designer 7.0 + JBoss Dev Studio 3.0.1GA Teiid 7.1 Alpha on EAP 5.1 RHEL 6, OpenJDK 1.6 Reporter: Ken Johnson In DTP, Context menu for Table contains several options under Data->(Edit, Load, Extract, Sample Contents). For virtual tables, Extract and Sample Contents are fine. Edit and Load will attempt to write data. Thus a few issues: a) These options should be disabled if the table in question does not have Supports Update checked. b) These options should be tested when the table *does* have Update and Insert procedures defined. c) Tables in SYS schema should never be writable. When working with physical tables, all options should be available and work correctly. Cursory testing indicates this is the case - at least with a MySQL data source underlying the model. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 9 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIIDDES-707) WSDL to Relational Importer can create procedures having same names, and params with same names.

by John Doyle (JIRA)

WSDL to Relational Importer can create procedures having same names, and params with same names. ------------------------------------------------------------------------------------------------ Key: TEIIDDES-707 URL: https://jira.jboss.org/browse/TEIIDDES-707 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 7.1 Reporter: John Doyle Assignee: John Doyle Fix For: 7.1.1 For some WSDLs the naming qualification and duplicate identification is not strong enough in the importer. As a result you can end up with same name procedures in a generated model, or duplicate names parameters in a procedure. The conflicting names can be fixed/qualified by the user. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 9 months

2
4
0 / 0

[JBoss JIRA] Created: (TEIIDDES-718) Designer should provide an option to expand the column names by default in the transformation.

by Ramesh Reddy (JIRA)

Designer should provide an option to expand the column names by default in the transformation. ---------------------------------------------------------------------------------------------- Key: TEIIDDES-718 URL: https://jira.jboss.org/browse/TEIIDDES-718 Project: Teiid Designer Issue Type: Feature Request Components: Transformations Reporter: Ramesh Reddy Priority: Minor When a default transformation is created when a virtual base table is created, it always creates a table with select * from foo some time it is desirable to generate to query in fully extended format as select c1, c2, ... from foo This could be designed as "preference" for Designer transformation. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 9 months

2
8
0 / 0

[JBoss JIRA] Created: (TEIIDDES-268) "Create Web Service" wizard on a virtual procedure produces invalid SQL in transformation

by Debbie Steigner (JIRA)

"Create Web Service" wizard on a virtual procedure produces invalid SQL in transformation ----------------------------------------------------------------------------------------- Key: TEIIDDES-268 URL: https://jira.jboss.org/jira/browse/TEIIDDES-268 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 7.0 Reporter: Debbie Steigner Fix For: 7.0 If you use our "Create Web Service" wizard on a virtual procedure the SQL transformation for the Output View is invalid for the current product. For example, our wizard produced: SELECT * FROM (EXEC TwoStepsFeatureTable.TwoSteps(left_node = left_node)) AS TwoSteps so it errors on left_node: Resolver Error: Symbol left_node is specified with an unknown group context The transformation should be procedural relational instead: SELECT * FROM TwoStepsFeatureTable.TwoSteps -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 9 months

3
5
0 / 0

[JBoss JIRA] Created: (TEIIDDES-210) Add implicit conversion of NULL to correct datatype in transformation validator

by Marc Shirley (JIRA)

Add implicit conversion of NULL to correct datatype in transformation validator ------------------------------------------------------------------------------- Key: TEIIDDES-210 URL: https://jira.jboss.org/jira/browse/TEIIDDES-210 Project: Teiid Designer Issue Type: Feature Request Components: Transformations, Validation Affects Versions: 6.0.0, 6.1.0 Reporter: Marc Shirley When using NULL value as a column (ie, NULL as columnName), it is only implicitly converted to a string. When trying to use the NULL as a column of type date, integer, float, etc., the validator throws a warning that the transformation is not valid. If you wrap the NULL in a convert to the correct column datatype (ie, "convert(NULL,date)"), the transformation can be validated successfully. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 9 months

3
3
0 / 0

[JBoss JIRA] Created: (TEIIDDES-188) Database Schema not used in sql query

by Ben Truitt (JIRA)

Database Schema not used in sql query ------------------------------------- Key: TEIIDDES-188 URL: https://jira.jboss.org/jira/browse/TEIIDDES-188 Project: Teiid Designer Issue Type: Bug Environment: Ubuntu 9.x eclipse 3.4.2 teiid_designer_6.0.0.v20090427_SNAPSHOT Postgresql 8.2 postgresql-8.3-604.jdbc4.jar Reporter: Ben Truitt It looks like the database schema specified in the XMI file for the model is not being used when generating the SQL query to preview data from the model. I'm attaching my model XMI file. Note the schema is named "rollback". However, the SQL query generated does not include the schema name, instead it only includes the table name. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 9 months

4
5
0 / 0

[JBoss JIRA] Created: (TEIIDDES-304) External metadata needs to be marked as scalar groups where appropriate

by Van Halbert (JIRA)

External metadata needs to be marked as scalar groups where appropriate ----------------------------------------------------------------------- Key: TEIIDDES-304 URL: https://jira.jboss.org/jira/browse/TEIIDDES-304 Project: Teiid Designer Issue Type: Task Components: Modeling Reporter: Van Halbert Priority: Minor Fix For: 7.1 External temp metadata supplied by the designer should be marked as coming from a scalar group for INPUT, CHANGING, and VARIABLES groups. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 9 months

3
2
0 / 0

[JBoss JIRA] Created: (TEIIDDES-724) Action to "Expand SELECT *" does nothing if the SELECT is part of a UNION

by Paul Nittel (JIRA)

Action to "Expand SELECT *" does nothing if the SELECT is part of a UNION ------------------------------------------------------------------------- Key: TEIIDDES-724 URL: https://jira.jboss.org/browse/TEIIDDES-724 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 7.1.1 Environment: JBDS 4.0 B2 (build 11/28) Reporter: Paul Nittel Priority: Minor While verifying TEIIDDES-693, I tried to expand the SELECT * on the UNIONs. All that happens is the cursor moves to the 1, 1 position in the SQL editor. No exception. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 9 months

3
3
0 / 0

[JBoss JIRA] Created: (TEIIDDES-570) Valid names can have almost any character, except periods. No periods!

by Paul Nittel (JIRA)

Valid names can have almost any character, except periods. No periods! ---------------------------------------------------------------------- Key: TEIIDDES-570 URL: https://jira.jboss.org/browse/TEIIDDES-570 Project: Teiid Designer Issue Type: Bug Components: Validation Affects Versions: 7.1 Environment: All Reporter: Paul Nittel This SQL: SELECT t.* FROM (EXEC WeatherData.invoke(action = 'GET', endpoint = QUERYSTRING('', '38.99,-77.02 39.70,-104.80 47.6,-122.30' AS listLatLon, 'time-series' AS product, '2004-01-01T00:00:00' AS "begin", '2013-04-20T00:00:00' AS "end", 'maxt' AS maxt, 'mint' AS mint))) AS w, XMLTABLE('/dwml/data/location' PASSING result COLUMNS "location-key" string, lattitude string PATH 'point/@latitude', longitude string PATH 'point/@longitude') AS t will fail as location-key contains a hyphen. Actually, the only character which is not valid in a name is the period. Please verify with the Teiid server crew, but we should loosen up the validation criteria as appropriate. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 9 months

3
9
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues January 2011