January 2017 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-3019) Import new model into existing model very confusing

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3019?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-3019: -------------------------------------- Assignee: Barry LaFond > Import new model into existing model very confusing > --------------------------------------------------- > > Key: TEIIDDES-3019 > URL: https://issues.jboss.org/browse/TEIIDDES-3019 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Affects Versions: 10.0.2 > Environment: JBoss Developer Studio 9.1.0.GA > Teiid Designer 10.0.2 > Reporter: Cojan van Ballegooijen > Assignee: Barry LaFond > Priority: Minor > Fix For: 11.0.1 > > Attachments: Review Model Update.png, Specify Import Option.png > > > The import dialog into an existing model is very confusing. > Have a simple Teiid project with an existing model > File->Import > JDBC-> Source model > Select a table from a connection > At the Specify Import Option check Update (if existing model selected) > Then you get Review Model Update > By default the old models will be deleted > - > I would suggest to uncheck the old models by default. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3019) Import new model into existing model very confusing

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3019?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-3019: ----------------------------------- Fix Version/s: 11.0.1 > Import new model into existing model very confusing > --------------------------------------------------- > > Key: TEIIDDES-3019 > URL: https://issues.jboss.org/browse/TEIIDDES-3019 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Affects Versions: 10.0.2 > Environment: JBoss Developer Studio 9.1.0.GA > Teiid Designer 10.0.2 > Reporter: Cojan van Ballegooijen > Assignee: Barry LaFond > Priority: Minor > Fix For: 11.0.1 > > Attachments: Review Model Update.png, Specify Import Option.png > > > The import dialog into an existing model is very confusing. > Have a simple Teiid project with an existing model > File->Import > JDBC-> Source model > Select a table from a connection > At the Specify Import Option check Update (if existing model selected) > Then you get Review Model Update > By default the old models will be deleted > - > I would suggest to uncheck the old models by default. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3015) Importing Flat File with "-" character in one column of the header

by Pedro Inácio (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3015?page=com.atlassian.jira.plu... ] Pedro Inácio commented on TEIIDDES-3015: ---------------------------------------- Similar problem occurs when running a query like the following: SELECT parseInteger(string_column, ',0;-,0') FROM table > Importing Flat File with "-" character in one column of the header > ------------------------------------------------------------------- > > Key: TEIIDDES-3015 > URL: https://issues.jboss.org/browse/TEIIDDES-3015 > Project: Teiid Designer > Issue Type: Bug > Environment: CentOs 7 + Teiid 9.1.2 with Wildfly 10.0.0.Final + Eclipse Neon with Designer 11. > Reporter: Pedro Inácio > > Trying to create a simple Flat File View Model from aCSV file with the following content: > {code:java} > "a-a","b" > 1,2 > 3,4 > {code} > Teiid server gives the following exception > {noformat} > [org.teiid.RUNTIME] (Worker6_async-teiid-threads6) TEIID50036 VDB PREVIEW-80ce0d21-f22d-431f-bd12-89ac57ac9418.1 model "ViewModel" metadata failed to load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a[*]-[*]a string" at line 3, column 10. > Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a[*]-[*]a string" at line 3, column 10. > Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ... > at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472) > at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:798) > at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40) > at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84) > at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) > at org.teiid.jboss.VDBService$6.run(VDBService.java:360) > at org.teiid.jboss.VDBService$7.run(VDBService.java:411) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a[*]-[*]a string" at line 3, column 10. > Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ... > at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214) > ... 13 more > {noformat} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3019) Import new model into existing model very confusing

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3019?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3019: ---------------------------------------- [~cvanball] So did you import a VDB containing a flat file source and View? because flat file source is not JDBC... or course :) > Import new model into existing model very confusing > --------------------------------------------------- > > Key: TEIIDDES-3019 > URL: https://issues.jboss.org/browse/TEIIDDES-3019 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Affects Versions: 10.0.2 > Environment: JBoss Developer Studio 9.1.0.GA > Teiid Designer 10.0.2 > Reporter: Cojan van Ballegooijen > Priority: Minor > Attachments: Review Model Update.png, Specify Import Option.png > > > The import dialog into an existing model is very confusing. > Have a simple Teiid project with an existing model > File->Import > JDBC-> Source model > Select a table from a connection > At the Specify Import Option check Update (if existing model selected) > Then you get Review Model Update > By default the old models will be deleted > - > I would suggest to uncheck the old models by default. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3019) Import new model into existing model very confusing

by Cojan van Ballegooijen (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3019?page=com.atlassian.jira.plu... ] Cojan van Ballegooijen commented on TEIIDDES-3019: -------------------------------------------------- [~blafond]This happens also with existing models based on a JDBC sources. I just created a couple of screenshots to show the dialog windows. The data source was in this case a flat file. > Import new model into existing model very confusing > --------------------------------------------------- > > Key: TEIIDDES-3019 > URL: https://issues.jboss.org/browse/TEIIDDES-3019 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Affects Versions: 10.0.2 > Environment: JBoss Developer Studio 9.1.0.GA > Teiid Designer 10.0.2 > Reporter: Cojan van Ballegooijen > Priority: Minor > Attachments: Review Model Update.png, Specify Import Option.png > > > The import dialog into an existing model is very confusing. > Have a simple Teiid project with an existing model > File->Import > JDBC-> Source model > Select a table from a connection > At the Specify Import Option check Update (if existing model selected) > Then you get Review Model Update > By default the old models will be deleted > - > I would suggest to uncheck the old models by default. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3019) Import new model into existing model very confusing

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3019?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3019: ---------------------------------------- [~cvanball] I think we can make that happen. However, the current behavior is designed to update an existing model based on schema that's been re-imported. So in this case, there is probably no "invoke" procedure in the source schema, so it shows up as a "delete". Your use-cases seems like you want to use a single source model to represent one or more different JDBC sources + user-defined tables/procedures? > Import new model into existing model very confusing > --------------------------------------------------- > > Key: TEIIDDES-3019 > URL: https://issues.jboss.org/browse/TEIIDDES-3019 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Affects Versions: 10.0.2 > Environment: JBoss Developer Studio 9.1.0.GA > Teiid Designer 10.0.2 > Reporter: Cojan van Ballegooijen > Priority: Minor > Attachments: Review Model Update.png, Specify Import Option.png > > > The import dialog into an existing model is very confusing. > Have a simple Teiid project with an existing model > File->Import > JDBC-> Source model > Select a table from a connection > At the Specify Import Option check Update (if existing model selected) > Then you get Review Model Update > By default the old models will be deleted > - > I would suggest to uncheck the old models by default. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3019) Import new model into existing model very confusing

by Cojan van Ballegooijen (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3019?page=com.atlassian.jira.plu... ] Cojan van Ballegooijen updated TEIIDDES-3019: --------------------------------------------- Description: The import dialog into an existing model is very confusing. Have a simple Teiid project with an existing model File->Import JDBC-> Source model Select a table from a connection At the Specify Import Option check Update (if existing model selected) Then you get Review Model Update By default the old models will be deleted - I would suggest to uncheck the old models by default. was: The import dialog into an existing model is very confusing. Have a simple Teiid project with an existing model File->Import JDBC-> Source model Select a table from a connection At the Specify Import Option check Update (if existing model selected) Then you get Review Model Update By default the old model will be deleted - I would suggest to uncheck the old models by default. > Import new model into existing model very confusing > --------------------------------------------------- > > Key: TEIIDDES-3019 > URL: https://issues.jboss.org/browse/TEIIDDES-3019 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Affects Versions: 10.0.2 > Environment: JBoss Developer Studio 9.1.0.GA > Teiid Designer 10.0.2 > Reporter: Cojan van Ballegooijen > Priority: Minor > Attachments: Review Model Update.png, Specify Import Option.png > > > The import dialog into an existing model is very confusing. > Have a simple Teiid project with an existing model > File->Import > JDBC-> Source model > Select a table from a connection > At the Specify Import Option check Update (if existing model selected) > Then you get Review Model Update > By default the old models will be deleted > - > I would suggest to uncheck the old models by default. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3019) Import new model into existing model very confusing

by Cojan van Ballegooijen (JIRA)

Cojan van Ballegooijen created TEIIDDES-3019: ------------------------------------------------ Summary: Import new model into existing model very confusing Key: TEIIDDES-3019 URL: https://issues.jboss.org/browse/TEIIDDES-3019 Project: Teiid Designer Issue Type: Enhancement Components: Import/Export Affects Versions: 10.0.2 Environment: JBoss Developer Studio 9.1.0.GA Teiid Designer 10.0.2 Reporter: Cojan van Ballegooijen Priority: Minor Attachments: Review Model Update.png, Specify Import Option.png The import dialog into an existing model is very confusing. Have a simple Teiid project with an existing model File->Import JDBC-> Source model Select a table from a connection At the Specify Import Option check Update (if existing model selected) Then you get Review Model Update By default the old model will be deleted - I would suggest to uncheck the old models by default. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3018) Provide complex user defined types

by Steven Hawkins (JIRA)

Steven Hawkins created TEIIDDES-3018: ---------------------------------------- Summary: Provide complex user defined types Key: TEIIDDES-3018 URL: https://issues.jboss.org/browse/TEIIDDES-3018 Project: Teiid Designer Issue Type: Feature Request Reporter: Steven Hawkins Related to TEIIDDES-3016 and TEIIDDES-3017 there should eventually be the define complex types (for each base type, clob, blob, xml, json, geomety) that includes faceting. DDL support will need to be provided accordingly. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3017) Allow type aliasing for simple data types

by Steven Hawkins (JIRA)

Steven Hawkins created TEIIDDES-3017: ---------------------------------------- Summary: Allow type aliasing for simple data types Key: TEIIDDES-3017 URL: https://issues.jboss.org/browse/TEIIDDES-3017 Project: Teiid Designer Issue Type: Enhancement Reporter: Steven Hawkins Related to TEIIDDES-3016 and TEIID-3624 a simplified mechanism for aliasing simple types should be provided. Faceting will not initially be considered. DDL support will be provided via TEIID-3624 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues January 2017