[JBoss JIRA] (TEIIDDES-2687) Dynamic VDB generation - Default value for string column problem (DDL)
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2687?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2687.
------------------------------------
Resolution: Out of Date
> Dynamic VDB generation - Default value for string column problem (DDL)
> ----------------------------------------------------------------------
>
> Key: TEIIDDES-2687
> URL: https://issues.jboss.org/browse/TEIIDDES-2687
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Patch Release, VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Matus Makovy
> Assignee: Mark Drilling
> Fix For: 10.0.2, 9.2.1
>
>
> I have a model with table that has String column with default value "Stock".
> DDL generated by TD for dynamic VDB looks like this:
> {quote}
> ...
> TYPE string(15) DEFAULT ('Stock') OPTIONS(NAMEINSOURCE '"TYPE"', NATIVE_TYPE 'VARCHAR2', UPDATABLE 'FALSE'),
> ...
> {quote}
> *DEFAULT ('Stock')* is not correct, it should be: *DEFAULT '("Stock")'*
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2788) Access Pattern not generated when exporting dynamic VDB
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2788?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2788:
--------------------------------------
Assignee: Barry LaFond
> Access Pattern not generated when exporting dynamic VDB
> -------------------------------------------------------
>
> Key: TEIIDDES-2788
> URL: https://issues.jboss.org/browse/TEIIDDES-2788
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Fix For: 10.0.2
>
> Attachments: APproj.zip
>
>
> When exporting a dynamic VDB, access pattern constrains on model tables are not exported.
> Actual DDL:
> {code:sql}
> CREATE FOREIGN TABLE s1 (
> newColumn_1 string(4000),
> newColumn_2 string(4000)
> )
> {code}
> Expected DDL:
> {code:sql}
> CREATE FOREIGN TABLE s1 (
> newColumn_1 string(4000),
> newColumn_2 string(4000),
> CONSTRAINT NewAccessPattern ACCESSPATTERN (newColumn_1)
> )
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2052) 'Mark as Deployable' on a war not working for remote (OpenShift) server
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2052?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2052:
-----------------------------------
Fix Version/s: 11.0
(was: 10.0.2)
> 'Mark as Deployable' on a war not working for remote (OpenShift) server
> -----------------------------------------------------------------------
>
> Key: TEIIDDES-2052
> URL: https://issues.jboss.org/browse/TEIIDDES-2052
> Project: Teiid Designer
> Issue Type: Bug
> Components: VDB & Execution
> Affects Versions: 8.3.1
> Reporter: Mark Drilling
> Assignee: Mark Drilling
> Fix For: 11.0
>
>
> I created a war (using Rest War generator) in Designer and added it to my project. Then to deploy it, I selected it and used the 'Mark as Deployable" action.
> This worked fine on my local server (both deploy and undeploy) but then I switched to an OpenShift external server instance (used port-forwarding).
> The 'Mark as Deployable' action doesnt work for the Openshift external server. Maybe the action is doing a copy of the war into the deployments folder?
> We don't provide the action, but we should either troubleshoot or potentially provide our own action which deploys a war using the admin api.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2716) Improve importing of dynamic VDBs
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2716?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2716:
-----------------------------------
Fix Version/s: 11.0
(was: 10.0.2)
> Improve importing of dynamic VDBs
> ---------------------------------
>
> Key: TEIIDDES-2716
> URL: https://issues.jboss.org/browse/TEIIDDES-2716
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Dynamic VDBs, VDB & Execution
> Reporter: Matus Makovy
> Fix For: 11.0
>
>
> If you want to import dynamic VDB now, you have to import a file to a project and then right-click the dynamic VDB and select Modeling -> Generate VDB archive and models.
> I thnik it could be more user friendly. For example there could be an option to import dynamic VDB using: File -> Import -> Dynamic VDB. One wizard would guide you through the whole import of the vdb xml file to the project.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2806) Generate Dynamic VDB: Columns with non-standard characters end up in the resulting xml without quotes, resulting in a an undeployable vdb
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2806?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2806.
------------------------------------
Resolution: Duplicate Issue
Duplicate of TEIIDDES-2858 (and TEIIDDES-2897)
> Generate Dynamic VDB: Columns with non-standard characters end up in the resulting xml without quotes, resulting in a an undeployable vdb
> ------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2806
> URL: https://issues.jboss.org/browse/TEIIDDES-2806
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Dynamic VDBs, Patch Release
> Affects Versions: 9.0.3, 9.2
> Reporter: Debbie Steigner
> Assignee: Barry LaFond
> Fix For: 10.0.2
>
>
> The Teiid vdb has column named e.g. PE$HOME. When I generate a dynamic vdb xml from this model, the xml document contains:
> CREATE FOREIGN TABLE MYTABLE (
> ID string(40) NOT NULL,
> NAME string(40),
> PE$HOME string(19) NOT NULL,
> CONSTRAINT FKI_MY_VIEW PRIMARY KEY(ID)
> )
> When i deploy this, it fails because P$HOME is not allowed as column name.
> I expect to see this name "quoted" in the xml vdb:
> CREATE FOREIGN TABLE MYTABLE (
> "ID" string(40) NOT NULL,
> "NAME" string(40),
> "PE$HOME" string(19) NOT NULL,
> CONSTRAINT FKI_MY_VIEW PRIMARY KEY(ID)
> )
> Proposed solution: always use "quotes" in source and view xml vdb, both for the column names, and the mapping statement.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2892) VDB file is not changed after some actions. No errors are shown.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2892?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2892:
--------------------------------------
Assignee: Barry LaFond
> VDB file is not changed after some actions. No errors are shown.
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2892
> URL: https://issues.jboss.org/browse/TEIIDDES-2892
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0
> Reporter: Bram Gadeyne
> Assignee: Barry LaFond
> Priority: Blocker
> Attachments: .log, after_reopen.png, after_sync_all.png, rights_still_present.png, take_away_rights.png
>
>
> Hi,
> I'm using teiiddesigner 10.0 and teiid server 9.0.2.
> I've copied a previous vdb file called vdb3.14.vdb to vbd3.15.vdb and changed the version number to 15.
> I've then added a new xmi for a new database which I've generated through JDBC import.
> Now I wanted to change the permissions on this new database but I can't seem to alter the vdb file anymore.
> First off all The vdb shown some models that are not in sync with the model files. Clicking on synchronize all first shows them as beiing updated but closing and reopening the vdb file shows that they are still nog in sync.
> Opening the editor to alter the permissions also seems to work. But when you reopen the panel for the same usergroup the changes are not made.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2881) Sizing issue in Teiid designer
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2881?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2881:
--------------------------------------
Assignee: Barry LaFond
> Sizing issue in Teiid designer
> ------------------------------
>
> Key: TEIIDDES-2881
> URL: https://issues.jboss.org/browse/TEIIDDES-2881
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations
> Affects Versions: 10.0.1
> Reporter: Harshul Madan
> Assignee: Barry LaFond
> Fix For: 10.0.2
>
> Attachments: Screen Shot 2016-07-22 at 9.01.00 AM.png, Screen Shot 2016-07-22 at 9.01.16 AM-1.png
>
>
> When we click on “Reconciler” icon in Transformation editor. The components in the window which opens is not programmed to support different screen size (i.e. doesn’t scale adequately).
> Details:
> MacBook Pro (Retina, 13.3-inch (2560 x 1600))
> Teiid Designer 9.0
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2858) DDL Importer does drops quotes from quoted column names
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2858?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2858:
-----------------------------------
Summary: DDL Importer does drops quotes from quoted column names (was: Column whose have specific name are not correctly parsed in the DDL)
> DDL Importer does drops quotes from quoted column names
> -------------------------------------------------------
>
> Key: TEIIDDES-2858
> URL: https://issues.jboss.org/browse/TEIIDDES-2858
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview, Dynamic VDBs
> Affects Versions: 10.0.1
> Environment: Fedora 23
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Fix For: 10.0.2
>
> Attachments: remoteXML.zip, screenshot1.png, screenshot2.png
>
>
> When I wanted preview date from the table which contains column with specific name, server shows me this error:
> TEIID31100 Parsing error: Encountered "'FALSE'), [*]YEAR[*] string(" at line 8, column 9.
> Was expecting: "constraint" | "foreign" | "primary" | "unique" | id
> I looked on the DDL which designer generated (screenshot1) and I think that column TIME should be between quotation marks.
> "YEAR" string(4000) OPTIONS(NAMEINSOURCE '"YEAR"', UPDATABLE 'FALSE')
> When I change column name from TIME to "TIME", the preview passed and showed me data. (screenshot2)
> A similar situation is when I generated dynamic VDB.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months