November 2010 - teiid-designer-issues

[JBoss JIRA] Created: (TEIIDDES-728) Execute VDB Action uses incorrect connection URL.

by John Doyle (JIRA)

Execute VDB Action uses incorrect connection URL. ------------------------------------------------- Key: TEIIDDES-728 URL: https://jira.jboss.org/browse/TEIIDDES-728 Project: Teiid Designer Issue Type: Bug Components: VDB & Execution Affects Versions: 7.1.1 Reporter: John Doyle Assignee: John Doyle Priority: Blocker Fix For: 7.1.1 The port should be 31000 and the protocol should be mm, not mms. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 1 month

2
4
0 / 0

[JBoss JIRA] Created: (TEIIDDES-403) Eliminate use of restricted Eclipse classes

by Barry LaFond (JIRA)

Eliminate use of restricted Eclipse classes ------------------------------------------- Key: TEIIDDES-403 URL: https://jira.jboss.org/jira/browse/TEIIDDES-403 Project: Teiid Designer Issue Type: Sub-task Affects Versions: 7.0 Reporter: Barry LaFond Fix For: 7.0 Designer still uses some restricted Eclipse classes. Goal is to become compliant with the restrictions. -- 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, 1 month

2
8
0 / 0

[JBoss JIRA] Created: (TEIIDDES-716) Remove importing of index information by default

by Ramesh Reddy (JIRA)

Remove importing of index information by default ------------------------------------------------ Key: TEIIDDES-716 URL: https://jira.jboss.org/browse/TEIIDDES-716 Project: Teiid Designer Issue Type: Task Components: Import/Export Reporter: Ramesh Reddy By default, when a import job is run on a JDBC data source, the indexes are selected by default. Indexes are not commonly used artifact during the runtime, so it provides minimal benefit. Make the importing of index information "false" by default. This will produce less cluttered model in the Designer. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 1 month

2
3
0 / 0

[JBoss JIRA] Created: (TEIIDDES-729) Teiid designer generates SQL*Plus specific statements

by Boris Belovic (JIRA)

Teiid designer generates SQL*Plus specific statements ----------------------------------------------------- Key: TEIIDDES-729 URL: https://jira.jboss.org/browse/TEIIDDES-729 Project: Teiid Designer Issue Type: Bug Components: Import/Export Reporter: Boris Belovic When generating DDL files for Oracle database, Teiid designer adds Oracle SQL*Plus specific statements into this DDL file. From discussion on #metamatrix channel turned out that these statements are specific to SQL*Plus tooling. With other tools (for example Ant's sql task) these commands cause failures and the DDL file doesn't execute correctly. For example following file: CREATE TABLE MVCloneMaterializedTable ( name VARCHAR2(255), surname VARCHAR2(255), label VARCHAR2(255) ); SET DEFINE OFF SET DEFINE ON -- Uncomment the following line for use of the logging facility --spool off commit; when executed through Ant's sql task will fail with this error: Failed to execute: SET DEFINE OFF SET DEFINE ON commit -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 1 month

2
4
0 / 0

[JBoss JIRA] Deleted: (TEIIDDES-614) Books and Parts sample projects do not include DDL scripts nor readme telling user how to set up data sources.

by Barry LaFond (JIRA)

[ https://jira.jboss.org/browse/TEIIDDES-614?page=com.atlassian.jira.plugin... ] Barry LaFond deleted TEIIDDES-614: ---------------------------------- > Books and Parts sample projects do not include DDL scripts nor readme telling user how to set up data sources. > -------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-614 > URL: https://jira.jboss.org/browse/TEIIDDES-614 > Project: Teiid Designer > Issue Type: Bug > Environment: Helios, RHEL 6, JBTools 3.2 M2 > Reporter: Ken Johnson > > The two sample projects included with Teiid Designer include a "data" folder but that folder is empty. Presumably it should contain DDL files to set up the Books and Parts data sources on a MySQL and/or PostgreSQL DB so the user can actually deploy and run the sample VDB. It should also include a readme file instructing the user on how to load the DDL and how to bind the source models to the data sources once populated with sample data. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 1 month

1
0
0 / 0

[JBoss JIRA] Created: (TEIIDDES-726) Teiid designer v7.1 generates comments in DDL files even if 'Generate comments' option is not checked

by Boris Belovic (JIRA)

Teiid designer v7.1 generates comments in DDL files even if 'Generate comments' option is not checked ------------------------------------------------------------------------------------------------------ Key: TEIIDDES-726 URL: https://jira.jboss.org/browse/TEIIDDES-726 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 7.1 Reporter: Boris Belovic Priority: Minor Teiid designer generates comments in DDL even if the 'Generate comments' option is not checked. The comments are there no matter if 'Generate comments' option is checked or unchecked. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 1 month

2
1
0 / 0

[JBoss JIRA] Created: (TEIIDDES-722) DB2 - 9.7 is missing in the DDL export menu

by Boris Belovic (JIRA)

DB2 - 9.7 is missing in the DDL export menu ------------------------------------------- Key: TEIIDDES-722 URL: https://jira.jboss.org/browse/TEIIDDES-722 Project: Teiid Designer Issue Type: Bug Components: Import/Export Reporter: Boris Belovic Teiid designer supports only DB2 7.x database. SOA-P ships with DB2 - 9.7 support, Teiid designer should reflect this. Especially when users try to generate DDL scripts used for external materialization. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 1 month

2
3
0 / 0

[JBoss JIRA] Created: (TEIIDDES-720) Re-connecting to existing Teiid server after server shutdown & restart causing multiple problems

by Barry LaFond (JIRA)

Re-connecting to existing Teiid server after server shutdown & restart causing multiple problems ------------------------------------------------------------------------------------------------ Key: TEIIDDES-720 URL: https://jira.jboss.org/browse/TEIIDDES-720 Project: Teiid Designer Issue Type: Bug Reporter: Barry LaFond If Server is stopped or crashes while Designer is running, the next "hit" on the server will result in error. After restarting server, Designer doesn't successfully re-set itself and Previewing data in workspace runs into server exceptions, etc... Need to add logic to Designer to "clean-up" cached info (VDB's, Preview VDB's, Data sources, etc...) and re-set the cached Server object and it's contents. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIIDDES-713) Virtual Model Import and Export to text does not work, and inconsistent

by Ramesh Reddy (JIRA)

Virtual Model Import and Export to text does not work, and inconsistent ----------------------------------------------------------------------- Key: TEIIDDES-713 URL: https://jira.jboss.org/browse/TEIIDDES-713 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 7.1 Reporter: Ramesh Reddy Right click on the virtual view -> Modeling - > Transformations - Export SQL generate file. Try to import the same file it does not work. Not only that, the text file generated does not match in format with "metadata import from Text file" import action. These should match and work. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIIDDES-712) Text metadata - transformation SQL editor fails to parse text with reserved word enclosed in quotation marks - no escape mechanism

by Paul Nittel (JIRA)

Text metadata - transformation SQL editor fails to parse text with reserved word enclosed in quotation marks - no escape mechanism ---------------------------------------------------------------------------------------------------------------------------------- Key: TEIIDDES-712 URL: https://jira.jboss.org/browse/TEIIDDES-712 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 7.1.1 Environment: JBDS 4.0.0 Beat 1, Fedora 12 Reporter: Paul Nittel Fix For: 7.1.1 I'm executing the TPCR Text metadata test and ran into the word "value" which is being used as a column name. Since it's reserved, it needs to be enclosed in quotes. Now, as part of a text metadata import, it's already a quoted string, so I need to somehow escape the quotation marks around value. \" and "" both failed to work. The metadata text is: Q11, "SELECT PS_PARTKEY, SUM((PS_SUPPLYCOST * PS_AVAILQTY)) AS value FROM TPCR.PARTSUPP, TPCR.SUPPLIER, TPCR.NATION WHERE (PS_SUPPKEY = S_SUPPKEY) AND (S_NATIONKEY = N_NATIONKEY) AND (N_NAME = 'GERMANY') GROUP BY PS_PARTKEY HAVING SUM((PS_SUPPLYCOST * PS_AVAILQTY)) > (SELECT (SUM((PS_SUPPLYCOST * PS_AVAILQTY)) * 1.0E-4) FROM TPCR.PARTSUPP, TPCR.SUPPLIER, TPCR.NATION WHERE (PS_SUPPKEY = S_SUPPKEY) AND (S_NATIONKEY = N_NATIONKEY) AND (N_NAME = 'GERMANY'))", "TPCR Query 11" The importer and/or parser should take into account the need to escape quotes. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

2
6
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues November 2010