December 2010 - teiid-designer-issues

[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

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

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

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

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

3
9
0 / 0

[JBoss JIRA] Created: (TEIIDDES-742) Add support for temp table permissions

by Steven Hawkins (JIRA)

Add support for temp table permissions --------------------------------------- Key: TEIIDDES-742 URL: https://issues.jboss.org/browse/TEIIDDES-742 Project: Teiid Designer Issue Type: Feature Request Components: Teiid Integration Affects Versions: 7.3 Reporter: Steven Hawkins the data-role element can now have a allow-create-temporary-tables attribute to specify whether the role allows the usage of temporary tables. There should be a check box on the role editor to account for this. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years

2
2
0 / 0

[JBoss JIRA] Created: (TEIIDDES-574) Datatypes editor: Changing name of datatype is not reflected in list "Datatypes in <your>.xsd"

by Paul Nittel (JIRA)

Datatypes editor: Changing name of datatype is not reflected in list "Datatypes in <your>.xsd" ---------------------------------------------------------------------------------------------- Key: TEIIDDES-574 URL: https://jira.jboss.org/browse/TEIIDDES-574 Project: Teiid Designer Issue Type: Bug Components: Modeling Affects Versions: 7.1 Environment: Fedora 12, JBDS 3.0.1, Teiid Designer 7.1M2 Reporter: Paul Nittel Priority: Minor While testing the simple datatypes editor we change the name of a datatype from PublicationYear to Temporary. When the change is made, the old name remains on the list of "Datatypes in BookDatatypes.xsd". Only after restarting the editor is the change noted in that list. Not a major issue, but it leaves the not-quite-finished impression. Reproduction steps are below. -- 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

3
6
0 / 0

[JBoss JIRA] Created: (TEIIDDES-217) JDBC Import Error from MySQL with BIT datatypes

by Mark Drilling (JIRA)

JDBC Import Error from MySQL with BIT datatypes ----------------------------------------------- Key: TEIIDDES-217 URL: https://jira.jboss.org/jira/browse/TEIIDDES-217 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 6.0.0, 6.1.0, 6.2.0, Future Reporter: Mark Drilling Assignee: Barry LaFond Priority: Minor JDBC import from a MySQL database having columns of BIT datatype fails. The import succeeds, but attempts to re-open the generated relational model fail. Further inspection of the .xmi shows that an incorrect 'defaultValue' for the column has been written to the xmi model file. -- 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

3
4
0 / 0

[JBoss JIRA] Created: (TEIIDDES-727) Preview of data based on previously created Conn Profile appears to use loopback conectr

by Paul Nittel (JIRA)

Preview of data based on previously created Conn Profile appears to use loopback conectr ---------------------------------------------------------------------------------------- Key: TEIIDDES-727 URL: https://jira.jboss.org/browse/TEIIDDES-727 Project: Teiid Designer Issue Type: Bug Components: VDB & Execution Affects Versions: 7.1.1 Environment: JBDS 4.0 Beta 2 (build is H12) Reporter: Paul Nittel I had an already-set up server which had previously been used to do similar previews and queries. I have no idea if that has anything to do with this. I found that under some unusual set of circumstances, previewing relational data (select table, click preview button) may return data from the loopback connector, instead of the connection to the actual data source. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years

2
6
0 / 0

[JBoss JIRA] Created: (TEIIDDES-178) Error initializing mirrors for: jar:file:C:\Documents and Settings\admindv.SLNTQM13\Desktop\teiid_designer_6.0.0.v20090430.zip!/

by Warren Gibson (JIRA)

Error initializing mirrors for: jar:file:C:\Documents and Settings\admindv.SLNTQM13\Desktop\teiid_designer_6.0.0.v20090430.zip!/ -------------------------------------------------------------------------------------------------------------------------------- Key: TEIIDDES-178 URL: https://jira.jboss.org/jira/browse/TEIIDDES-178 Project: Teiid Designer Issue Type: Bug Affects Versions: 6.0.0 Environment: Windows XP Client Reporter: Warren Gibson Priority: Minor I had downloaded Eclipse 3.4.1 and installed it as a fresh install. I got teiid_designer_6.0.0.v20090430 from SVN. The designer zip file was on my desktop. I took the normal steps to install designer. When it installed I got the following. This seems to happen with every install on the Windows client. Not sure if it is a defect or is related to the designer zip being on my desktop. Error initializing mirrors for: jar:file:C:\Documents and Settings\admindv.SLNTQM13\Desktop\teiid_designer_6.0.0.v20090430.zip!/ java.net.URISyntaxException: Relative path in absolute URI: jar://file:C:%5CDocuments%20and%20Settings%5Cadmindv.SLNTQM13%5CDesktop%5Cteiid_designer_6.0.0.v20090430.zip!/ at java.net.URI.checkPath(Unknown Source) at java.net.URI.<init>(Unknown Source) at org.eclipse.equinox.internal.p2.core.helpers.URLUtil.toURI(URLUtil.java:65) at org.eclipse.equinox.internal.p2.artifact.repository.MirrorSelector.<init>(MirrorSelector.java:106) at org.eclipse.equinox.internal.p2.artifact.repository.simple.SimpleArtifactRepository.getMirror(SimpleArtifactRepository.java:490) at org.eclipse.equinox.internal.p2.artifact.repository.simple.SimpleArtifactRepository.downloadArtifact(SimpleArtifactRepository.java:447) at org.eclipse.equinox.internal.p2.artifact.repository.simple.SimpleArtifactRepository.getArtifact(SimpleArtifactRepository.java:515) at org.eclipse.equinox.internal.p2.artifact.repository.MirrorRequest.transferSingle(MirrorRequest.java:162) at org.eclipse.equinox.internal.p2.artifact.repository.MirrorRequest.transfer(MirrorRequest.java:146) at org.eclipse.equinox.internal.p2.artifact.repository.MirrorRequest.perform(MirrorRequest.java:94) at org.eclipse.equinox.internal.p2.artifact.repository.simple.SimpleArtifactRepository.getArtifact(SimpleArtifactRepository.java:504) at org.eclipse.equinox.internal.p2.artifact.repository.simple.DownloadJob.run(DownloadJob.java:64) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55) -- 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

2
2
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues December 2010